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 |
|
Anurag_srivastavalko
Starting Member
3 Posts |
 Posted - 2012-03-21 : 06:46:16
|
| Hi,I have generated the profiler trace file using SQL Server 2005 for Server Side Tracing. My code is generating the .trc trace files successfully. I used following command to read the trace file: Select * from ::Fn_Trace_Gettable ('\\ServerA\Trace\ServerSideTrace_NYTBGEDWP01_4.trc', Default)" but i got the error: "File '\\ServerA\Trace\ServerSideTrace_4.trc' either does not exist or is not a recognizable trace file. Or there was an error opening the file.".I am trying to read the trace file from SQL Server 2008.Followings are in place:1) SQL Server is running on domain account.2) SQL Server service account has access on that folder where files are getting created.Does any one has any idea why is this happening?Thanks alot in advance.Regards,Anurag Gaurrav |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Anurag_srivastavalko
Starting Member
3 Posts |
Posted - 2012-03-21 : 22:15:46
|
| It worked, locally it's able to access the files. What needs to be done so that it can pickup those files from network. |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2012-03-22 : 03:38:16
|
| What happens when you run EXEC xp_cmdshell 'dir \\ServerA\Trace\'- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
Anurag_srivastavalko
Starting Member
3 Posts |
Posted - 2012-03-22 : 06:47:13
|
| It's listing the files which are available under Trace folder.Regards,Anurag |
|
|
|
GoranS
Starting Member
1 Post |
Posted - 2012-04-12 : 10:25:44
|
| Check the permission on the newly created trace files. Because the user has permission to access the folder but the newly created files don’t inherit the permission from the parent folder.I had the same problem and end up writing batch script that changed the permission of all the files in the folder every 15 seconds. |
|
|
|
|
|
|
Server Side Tracing-> ::Fn_Trace_Gettable()