RE: fn_trace_gettable Permissions Issue

SSC Guru

Points: 323504

March 4, 2011 at 9:25 am

SQLRandall did this idea work for you? I'm using a derivation of this technique to create a trace on the startup/restart of the server; i add a DML trace, and separately, a logon trace, and create/alter the views that i use to monitor them.

Was hoping it worked in more than my limited environment, where i query the views as a superuser, so probably miss any permissions issues.

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!