February 4, 2011 at 8:28 am
Good Day,
is there a way to schedule SQL Server Profiler as a job ?The y need to run on a continuous basis s for auditing . I tested a few scripts , but they all stopped after one minute
February 4, 2011 at 10:24 am
It is not advisable to run Profiler on a continous basis as it would lead to performance related issues.
For auditing, there are some new features available in SQL Server 2008, you could try that
Eg. Audits (under Security in SSMS)
M&M
February 4, 2011 at 11:06 am
lianv 90648 (2/4/2011)
Good Day,is there a way to schedule SQL Server Profiler as a job ?The y need to run on a continuous basis s for auditing . I tested a few scripts , but they all stopped after one minute
I would agree with Mohammed about continuous profiling, however, I have had the need in the past to start a trace via a SQL Agent job. Check out sp_trace_create in BOL (or here: http://msdn.microsoft.com/en-us/library/ms190362.aspx).
What are you auditing?
_____________________________________________________________________
- Nate
February 6, 2011 at 10:49 pm
Good Day,
thank you for the response . We are unfortunately unable to upgrade the database to SQL Server 2008 and will have to use Profiler for auditing as part of PCI compliance.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply