Re: Auditing SP Execute.

From: Pranay Pandya (ppandya_at_gmail.com)
Date: 02/23/05

Next message: Peter: "Re: Logins created by default"
Previous message: Andrew J. Kelly: "Re: Profiler"
In reply to: Andrew J. Kelly: "Re: Auditing SP Execute."
Next in thread: Andrew J. Kelly: "Re: Auditing SP Execute."
Reply: Andrew J. Kelly: "Re: Auditing SP Execute."
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: 23 Feb 2005 11:42:41 -0800

I want to capture the user name and the time (using sql). i dont want
to run profiler for ever. When someone runs the sp may be i can get
the userid and insert it into a table.

Next message: Peter: "Re: Logins created by default"
Previous message: Andrew J. Kelly: "Re: Profiler"
In reply to: Andrew J. Kelly: "Re: Auditing SP Execute."
Next in thread: Andrew J. Kelly: "Re: Auditing SP Execute."
Reply: Andrew J. Kelly: "Re: Auditing SP Execute."
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Relevant Pages

Re: how to write sql to use Profiler to capture sql and sp running longer than 5 sec
... In the subject you write "how to write sql to use Profiler to capture sql ... and sp running longe" but when you ask the question you wrote ... Look up system stored procedures in the BOL that you can run to capture the ...
(microsoft.public.sqlserver.programming)
Re: Capturing SQL code that generates error
... Profiler to capture the statement and the error. ... Installer .MSI schema into a SQL database. ... the error message is produced. ...
(microsoft.public.sqlserver.server)
Re: find out how often is a table get updated/inserted
... You can use profiler, capture the data to a file or table... ... The event should be SQL Statement Ending. ... Wayne Snyder, MCDBA, SQL Server MVP ...
(microsoft.public.sqlserver.server)
RE: How can I get the last login date for a login ????
... You could capture it using SQL ... Profiler and output the information to a SQL table, ... triggers on user tables to track this. ...
(microsoft.public.sqlserver.security)
Re: SQL Profiler
... > ich verwende SQL Server 2000. ... > die mir mit SET STATISTICS ON; ... > Ich habe im SQL Profiler unter "Leistung" Execution Plan, ...
(microsoft.public.de.sqlserver)