Re: Log Reader

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 09/07/04 

Date: Tue, 7 Sep 2004 21:11:11 +0100

Make sure you are specifying a valid path on the SQL Server computer. If you
want to save the output to a different machine, then provide a UNC name.
Also make sure SQL Server service account has permissions to the path you
are writing to. 

-- 
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Percio" <Percio@discussions.microsoft.com> wrote in message
news:F8AADA4C-7C9B-401F-B7EF-F70AB4FE9F15@microsoft.com...
Thanks a lot for the help but when I run your store procedures and try to
execute i keep getting this message info
(1 row(s) affected)
Server: Msg 50000, Level 16, State 1, Procedure CreateTrace, Line 125
Failed to create trace. Error: File not created. Source: CreateTrace
Thanks
"Narayana Vyas Kondreddi" wrote:
> There isn't a user friendly way to read SQL Server transaction logs. There
> are some commands/functions provided, but are undocumented or not much
> information published on them. For example:
>
> DBCC LOG
> fn_dblog
>
> There are third party tools that can do this, like Lumigent Log Explorer,
> LogPi etc.
>
> However, for your requirement, you could use Profiler or Server side
tracing
> stored procedures to track the activity of specific users. For example:
>
> Automating Server Side Tracing in SQL Server
> http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
>
> Identifying performance issues using SQL Server Profiler
> http://vyaskn.tripod.com/analyzing_profiler_output.htm
> -- 
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
>
> "Percio" <Percio@discussions.microsoft.com> wrote in message
> news:C3EF98BE-8052-448A-8E40-62115C2686AF@microsoft.com...
> I am trying to know how can I read the logs made by a sql server during a
> period of time. For example I would like to know if a user connects to the
> sql server and start to do alter, create sql objects. My purpose is to
track
> my developer users in my sql server. Is there any native store procedure
to
> read that ??
>
>
>

Relevant Pages

  • Re: Error re-installing SQL Server 2005
    ... i actually was able to export the reg entries from my ... SQL Server Setup could not connect to the database service for server ... Refer to server error logs and setup logs for ... For details on how to view setup logs, ...
    (microsoft.public.sqlserver.setup)
  • Re: Cluster will not fail over.
    ... Could not recover the master database! ... If you intend to stay on SP3 (for SQL Server), you should at least apply the ... >> From SQL server logs ...
    (microsoft.public.sqlserver.clustering)
  • Re: Error re-installing SQL Server 2005
    ... SQL Server Setup could not connect to the database service for server ... Refer to server error logs and setup logs for more ... For details on how to view setup logs, ... Kevin Struckhoff ...
    (microsoft.public.sqlserver.setup)
  • Re: Error re-installing SQL Server 2005
    ... Kevin Struckhoff ... > decided to try out sql server 2008 rc0. ... Refer to server error logs and setup logs for ... For details on how to view setup logs, ...
    (microsoft.public.sqlserver.setup)
  • Re: host_name
    ... When the user logs in, ... >> of a client from sql server. ... >> For security reasons every user of our database system logs into our ... >> This can't be changed as we are limited to 3 database users. ...
    (comp.databases.ms-sqlserver)