Friday, March 6, 2015

How can get SQL Trace File Path ?

SELECT REVERSE(SUBSTRING(REVERSE(path),CHARINDEX('\',REVERSE(path)),LEN(path)))+'log.trc'
FROM sys.traces WHERE path LIKE '%\MSSQL\Log\log%.trc';

No comments:

Post a Comment