Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dhw
Constraint Violating Yak Guru
332 Posts |
 Posted - 2008-07-07 : 19:51:43
|
| Hello - I used techniques from this site (http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm)to create a server-side trace file. It worked great..as far as creating the file. But now I cannot open the file in the SQL Profiler...I get an Acess Denied message. Has anyone see this before?Thanks for any help - will |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-07 : 23:03:34
|
| Denied access on files or sql instance that generated trace? Are files on sql server's local disk? |
 |
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2008-07-08 : 10:37:42
|
| Yes. The files were generated by my local sql server....on my local disk drive. |
|
|
|
maninder
Posting Yak Master
100 Posts |
Posted - 2008-07-08 : 14:28:11
|
| you need to STOP the Tace to open it.. Else you are going to get Errors.exec sp_trace_setstatus @traceid=1, @status=0 - STOP Traceyou need to Figure out the TRACE ID by Select * from ::fn_trace_getinfo(DEFAULT)exec sp_trace_setstatus @traceid=1, @status=2 - Delete traceManinderSQL server Architect / Admin (DEV&PROD) |
|
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2008-07-08 : 14:35:27
|
| I actually did all of that, and still not working.I will try another approach.Thanks for the help. - will |
|
|
|
|
|
|
Cannot open trace file