Saved trace file is not opening.

Trace file which is saved through sp_trace_create is unable to open. It says Access is denied. Even though the trace is stopped.

Select * from ::fn_trace_getinfo(DEFAULT)

Thanks Satish

more ▼

asked Jul 12, 2012 at 07:39 PM in Default

avatar image

0 2 2 3

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.

Jul 12, 2012 at 09:03 PM SirSQL

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:\profiler\friday.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

Jul 13, 2012 at 01:27 PM Satish17

How are you trying to open the trace file? What exact error you are prompted?

Jul 13, 2012 at 01:30 PM Usman Butt

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.

Jul 13, 2012 at 01:41 PM Satish17

With which user you are connecting to SQL Profiler? Does that user have enough permissions? Moreover, what is the output of

 Select * from ::fn_trace_getinfo(DEFAULT)
Jul 13, 2012 at 01:48 PM Usman Butt
show all comments (comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 12, 2012 at 07:39 PM

Seen: 2004 times

Last Updated: Jul 16, 2012 at 02:53 PM

Copyright 2018 Redgate Software. Privacy Policy