InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 06:25:24 GMT20http://www.sqlservercentral.com/Forums/Topic1034476-146-1.aspxYou can try stopping and closing the trace. Then try again. I am not sure what your whole trace setup looks like, but you need to add events, columns, filters, etc. Here is an article that goes into the basics of tracing with SQL commands:[url=http://www.sqloptimizationsschool.com/Pages/Tracking%20Performance/Performance%20Tracing.aspx]SQL Performance Trace[/url]Microsoft's articles are really good as well.Wed, 20 Jul 2011 15:37:36 GMTjasonwi1202http://www.sqlservercentral.com/Forums/Topic1034476-146-1.aspxCan you please post the script I want to see a sample so I can modify the file sizeWed, 20 Jul 2011 14:16:29 GMTallamirohttp://www.sqlservercentral.com/Forums/Topic1034476-146-1.aspxThanks.Fri, 17 Dec 2010 08:03:27 GMTramadesai108http://www.sqlservercentral.com/Forums/Topic1034476-146-1.aspxI'm not familiar with that tool. I use SQL profiler to open the .trc fileWed, 15 Dec 2010 09:28:03 GMThomebrew01http://www.sqlservercentral.com/Forums/Topic1034476-146-1.aspxIt is working and it is now creating the files. I have not made any changes since yesterday and this morning it is working and i have no clue why. But now when I try to open the trace file it gives me a message "There was a problem sending the command to the program". It is trying to open the file thru ATL/MFC Trace Tool. Any ideas?Thanks for your time.Wed, 15 Dec 2010 05:32:17 GMTramadesai108http://www.sqlservercentral.com/Forums/Topic1034476-146-1.aspxWhen you run this: select * from sys.tracesWhat is in "path" ?Tue, 14 Dec 2010 13:42:26 GMThomebrew01http://www.sqlservercentral.com/Forums/Topic1034476-146-1.aspxThe trace is running but it does not create the file.Tue, 14 Dec 2010 13:14:23 GMTramadesai108http://www.sqlservercentral.com/Forums/Topic1034476-146-1.aspxDid you remember to turn the trace on? sp_trace_setstatus needs to be run to turn it on. Till you do that, it won't create any files.Tue, 14 Dec 2010 10:09:29 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic1034476-146-1.aspxSounds like you already have a trace running that's outputting to your desired filename.What are the results of: select * from sys.tracesTue, 14 Dec 2010 09:55:07 GMThomebrew01http://www.sqlservercentral.com/Forums/Topic1034476-146-1.aspxI am trying to create a trace using the following where @outputfilename is "\\mycomputer\mysharedfolder\tracefilename"exec @rc = sp_trace_create @TraceID output, 0, @OutputFileName, @MaxFileSize, @EndTimeThe problem is that it does not create the file in that location and yet the trace is running on the serveI have given full permission to "everyone" on that folder.If I create a file named "tracefilename.trc" manually and then run the trace, it gives me a message that the file already exists.Any ideas???Thanks.Tue, 14 Dec 2010 08:34:03 GMTramadesai108