Tag Info

New answers tagged

-2

SQL Server traces and Profiler can be used for auditing, but as the feature is announced to be deprecated in future versions of SQL Server, it’s not recommended to use this approach moving forward.


2

I had the same issue. I ran an SQL trace on a remote server and transferred the trace files to a local directory on my workstation so that I load the data into a table on my local SQL Server instance for running queries against. SELECT * INTO ProfileTracesTable FROM ::fn_trace_gettable('C:\Users\anthony\Documents\SQL_traces\first.trc', default) However, ...



Top 50 recent answers are included