Re: Logging

From: Steve Thompson (stevethompson_at_nomail.please)
Date: 10/06/04 

Date: Wed, 6 Oct 2004 11:34:12 -0400

"alltel news" <kenwebster@carolinadotrr.com> wrote in message
news:07U8d.3$A_3.0@fe39.usenetserver.com...
> Is there a way to extract information from the SQL Server logs about
stored
> procedure calls, triggers, etc. after they run? I'm trying to "reverse
> engineer" and application I inherited. My plan is to run the application,
> then look at the logs and see what it did under the covers.
>

Check out SQL Server profiler, you can capture traces, even play them back.
Wealth of information...

Steve

Relevant Pages

  • Re: Network login problem
    ... Please explain why the events is logged in the SQL server logs if remote connections is not enabled. ... login locally. ...
    (microsoft.public.sqlserver.connect)
  • viewing logs on clustered sql server
    ... anyone had a problem where on a clustered sql server, ... from within enterprise manager> management> sql server logs ...
    (microsoft.public.sqlserver.setup)
  • Re: MSDE - Just Stops!
    ... Verify the SQL Server Logs as well for any errors. ... to check the logs atleast once a day. ... > Suddenly today it just stopped running. ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL2K OLAP Stopping
    ... In my case, when some part of FAT related to Data folder was broken long time ago, ... What buffles us is that after checking the event logs and SQL Server logs, there is no indication that it did stop. ...
    (microsoft.public.sqlserver.olap)
  • Re: Connecting to Oracle Guru needed
    ... you also have the ability to import data from virtually any data source--including Oracle. ... SSIS or the SqlClient.SqlBulkCopy classes to import the Oracle data into a SQL Server table and use it there. ... connect to Oracle and extract information for a information board. ...
    (microsoft.public.sqlserver.connect)