x

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

Satish17 gravatar image

Satish17
0 2 2 2

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1842

asked: Jul 12, 2012 at 07:39 PM

Seen: 1184 times

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