Re: Log Reader

From: Percio (Percio_at_discussions.microsoft.com)
Date: 09/09/04 

Date: Thu, 9 Sep 2004 12:45:07 -0700

Thanks so much for the help but there is one more thing that I see i can do
by using profile but not using the sp's. Is there a way i can keep the trace
information into a table using the sps you mentioned to me ??

Thanks

"Andrew J. Kelly" wrote:

> The path you specify is from the servers viewpoint and not yours. Even
> though you may be runing the script from QA on your machine the trace file
> will get put on the server under the specified path.
>
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Percio" <Percio@discussions.microsoft.com> wrote in message
> news:03B58279-57DD-44A7-B665-95B3AB824D44@microsoft.com...
> > Thanks so much and sorry for the stupid questions but now for some reason
> > that i dont know yet i could create the tracing, but now i am having a new
> > issue. After run one of your examples i get a successfull message but the
> > .trc file is not being created phisically in my machine, then i run the
> > comand to stop and clear the trace and re run the commands and it say the
> > file already exists, then i set the option to overwrite and it goes ok but
> i
> > never get the .trc file on the path i specified and when also i run the
> > command
> > declare @FileExists int
> > EXEC master..xp_fileexist 'D:\Test1.trc', @FileExists OUT
> > print @FileExists
> >
> > it say the file still there, very weird to me because i dont see the file
> > there. how do i open this file to see the tracing i am getting ?
> >
> > Thanks for now
> >
> > Percio
> >
> > "Narayana Vyas Kondreddi" wrote:
> >
> > > 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: Log Reader
    ... Andrew J. Kelly SQL MVP ... >> though you may be runing the script from QA on your machine the trace ... >> Andrew J. Kelly SQL MVP ... >>> comand to stop and clear the trace and re run the commands and it say ...
    (microsoft.public.sqlserver.programming)
  • Re: Rexx IRXIC and IRXEXEC question
    ... cannot replace the IO routines and run TSO commands. ... The Rexx IRXIC (Trace and Execution control) allows one to enter some ... TS command to turn on tracing, then run an exec with IRXECEC. ...
    (bit.listserv.ibm-main)
  • Re: tracking SPID back to the user or client
    ... You can run a trace and at some point you should see a cursor prepare ... Andrew J. Kelly SQL MVP ... or database code to see why it is blocking and fix the source. ... The connection is made through ODBC. ...
    (microsoft.public.sqlserver.connect)
  • Re: Switching from tcsh to bash as an interactive shell
    ... > Are you perhaps suggesting that the shell append to it throughout ... > trying to write a linear sequence of commands. ... > shell, the trace forks. ... How about interleaving segmentwise (maintain order ...
    (comp.os.linux.misc)
  • Re: Switching from tcsh to bash as an interactive shell
    ... > Are you perhaps suggesting that the shell append to it throughout ... > trying to write a linear sequence of commands. ... > shell, the trace forks. ... How about interleaving segmentwise (maintain order ...
    (comp.unix.shell)
Loading