|
Trace file which is saved through sp_trace_create is unable to open. It says Access is denied. Even though the trace is stopped.
Thanks Satish
(comments are locked)
|
Once you sign in you will be able to subscribe for any updates here
By RSS:Topics:
asked: Jul 12 '12 at 07:39 PM
Seen: 449 times
Last Updated: Jul 16 '12 at 02:53 PM
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.
Are you running that query in an attempt to access the data in the trace file? That query will only give you a list of the running traces on the server and you must have (at minimum) ALTER TRACE permissions on the server.
Im sorry actually i should have explained clearly., Firstly, i created a procedure with setup of trace events, and i created a job which run automatically and save the trace file in production server in particular drive. Eg. Say today is friday,and i have given a full permission in the production server for the folder c:profiler for my login. Now, the trace file friday.trc is saved in the folder c:profilerfriday.trc. Now, my problem is i cannot able to open the file friday.trc, eventhough the trace is stopped. i'm running sql agent job with "SA" login. Any questions pls ask me.
Thanks Satish
How are you trying to open the trace file? What exact error you are prompted?
Failed to open a file. Access is denied. I feel there is some things with the security permission in sql2008 profiler but i cant find.
With which user you are connecting to SQL Profiler? Does that user have enough permissions? Moreover, what is the output of