![sql server 2012 profiler sql server 2012 profiler](https://windows-cdn.softpedia.com/screenshots/dbForge-Event-Profiler-for-SQL-Server_2.jpg)
If you are writing from - remote server to local drive, please use UNC path and make sure server has - write access to your network share declare nvarchar(300) trc extension - will be appended to the filename automatically. Please replace the text InsertFileNameHere, with an appropriate - filename prefixed by a path, e.g., c:\MyFolder\MyTrace. * Created by: SQL Server 2014 Profiler */ĪS - Create a Queue declare int declare int declare bigint WHERE NAME = 'scan for startup procs' GO Create proc SPTroubelTrace GO SELECT VALUE, VALUE_IN_USE, DESCRIPTION Verify start option value is 1 USE MASTER Mark Trace Store Proc startup option True EXEC sp_procoption 'StoreProcName', 'startup', 'true' see if trace is running select * from sys.traces Script used in the video To Automatically Restart SQL Profiler after SQL Server Service Restart