I am trying to set up a trace on a remote server. I am able to generate the trace, set filters, and even stop and delete the trace through sql server without an issue. However, the file created with sp_trace_create seems to be owned by the SQL Service and I do not have administrative permission to grant myself read-access.
- Is there something similar to Oracle's
trace_files_publicfor SQL Server 2008 R2?
"There is an undocumented parameter _trace_files_public that if set to true changes the file permissions in the user_dump_dest directory when trace files are created to allow everyone to read them." (http://www.petefinnigan.com/ramblings/how_to_set_trace.htm)
Is there a way I can view the contents through SMSS (since I seem to have adequate permission there, if not to the file itself?)
Something else that would be even better I haven't considered?
Sorry if my terminologies are rough--the whole dba thing is new to me.
Thanks in advance! My sys-admin will appreciate not being bugged to set permissions (again.)