Hi,

Consider the following command in QA:

exec @rc = sp_trace_create @TraceID output, 2, @FileName
, @maxfilesize, @Datetime

The trace file (pointed in @FileName variable as
'\\RS001\SR001\MyDir\Trc-2007-07-31T09-37-01-933') is directed to a
remote server "RS001" which has "SH001" as a shared folder (I have write
permission. in that folder) I use this same file name in profiler tool
and get success. But using it in sp_trace_create I get @RC=12 that means
"the file was not created".

I don't see any clue in error-log nor in event viewer.

I would appreciate any help on this, please.

Gilnei


MS Sql Server LazyDBA home page