InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 05:17:52 GMT20http://www.sqlservercentral.com/Forums/Topic699417-65-1.aspxLike we all haven't done the same thing a hundred times. That's what the extra set of eyes is for.Fri, 17 Apr 2009 08:35:12 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic699417-65-1.aspxOk... now I feel like an idiot... Thank you.. not sure how I deleted the @.. Thanks againFri, 17 Apr 2009 08:20:00 GMTStephen Knotthttp://www.sqlservercentral.com/Forums/Topic699417-65-1.aspxWell if the code you posted is the exact code you used then your problem is that you are missing the '@' sign before OutPutFileName in the sp_trace_create call here's your code:[code]exec @rc = sp_trace_create @TraceID output, 0, OutputFileName, @maxfilesize, @EndTime [/code]And here's what it should be:[code]exec @rc = sp_trace_create @TraceID output, 0, @OutputFileName, @maxfilesize, @EndTime [/code]Fri, 17 Apr 2009 08:16:08 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic699417-65-1.aspxHi, I am trying to use an idea from Gail's idea found at..http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/I have created the follow script from profiler.. Running it give me error : 12 - which I believe is File not created. I have checked, there are no other traces running, and the SQL service has access to the folder. I have tried creating this even in the folder where the data files live, to ensure that it had access.Is there anything else I can check ? Below is my script : /****************************************************//* Created by: SQL Profiler *//* Date: 16/04/2009 12:29:20 *//****************************************************/-- Create a Queuedeclare @rc intdeclare @TraceID intdeclare @maxfilesize bigintset @maxfilesize = 500 declare @OutputFileName nvarchar(200)declare @EndTime datetimeSET @OutputFileName = 'D:\Trace\ServerTrace' + CONVERT(VARCHAR(20), GETDATE(),112) + REPLACE(CONVERT(VARCHAR(20), GETDATE(),108),':','')SET @EndTime = DATEADD(mi,30,getdate())-- Please replace the text InsertFileNameHere, with an appropriate-- filename prefixed by a path, e.g., c:\MyFolder\MyTrace. The .trc extension-- will be appended to the filename automatically. If you are writing from-- remote server to local drive, please use UNC path and make sure server has-- write access to your network shareexec @rc = sp_trace_create @TraceID output, 0, OutputFileName, @maxfilesize, @EndTime if (@rc != 0) goto error-- Client side File and Table cannot be scripted-- Set the eventsdeclare @on bitset @on = 1exec sp_trace_setevent @TraceID, 10, 1, @onexec sp_trace_setevent @TraceID, 10, 6, @onexec sp_trace_setevent @TraceID, 10, 9, @onexec sp_trace_setevent @TraceID, 10, 10, @onexec sp_trace_setevent @TraceID, 10, 11, @onexec sp_trace_setevent @TraceID, 10, 12, @onexec sp_trace_setevent @TraceID, 10, 13, @onexec sp_trace_setevent @TraceID, 10, 14, @onexec sp_trace_setevent @TraceID, 10, 16, @onexec sp_trace_setevent @TraceID, 10, 17, @onexec sp_trace_setevent @TraceID, 10, 18, @onexec sp_trace_setevent @TraceID, 12, 1, @onexec sp_trace_setevent @TraceID, 12, 6, @onexec sp_trace_setevent @TraceID, 12, 9, @onexec sp_trace_setevent @TraceID, 12, 10, @onexec sp_trace_setevent @TraceID, 12, 11, @onexec sp_trace_setevent @TraceID, 12, 12, @onexec sp_trace_setevent @TraceID, 12, 13, @onexec sp_trace_setevent @TraceID, 12, 14, @onexec sp_trace_setevent @TraceID, 12, 16, @onexec sp_trace_setevent @TraceID, 12, 17, @onexec sp_trace_setevent @TraceID, 12, 18, @on-- Set the Filtersdeclare @intfilter intdeclare @bigintfilter bigintexec sp_trace_setfilter @TraceID, 10, 0, 7, N'SQL Profiler'exec sp_trace_setfilter @TraceID, 10, 0, 7, N'Microsoft Dynamics NAV client'-- Set the trace status to startexec sp_trace_setstatus @TraceID, 1-- display trace id for future referencesselect TraceID=@TraceIDgoto finisherror: select ErrorCode=@rcfinish: goFri, 17 Apr 2009 07:40:23 GMTStephen Knott