RE: Monitoring Changes to Users in databases.

SSC Guru

Points: 323504

July 31, 2012 at 7:03 am

#1519694

beautiful correction and thank you,

I updated my snippets with a note so i remember that.

thanks!

opc.three (7/31/2012)
The DEFAULT option works as you described, but you'll need to set @path this way if you want to pickup all default trace files:
SELECT @path = REVERSE(SUBSTRING(REVERSE([path]), CHARINDEX('\', REVERSE([path])), 260)) + N'log.trc'
FROM sys.traces
WHERE is_default = 1;

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!