SQL Trace Server Side for Named instance

• Hollyz

  SSCommitted

  Points: 1763

  More actions

  May 15, 2008 at 2:15 pm

  #122002

  I have a server Side Trace and ran it as a job from my named sql server 2005 instance.

  However, the Server Side Trace is Tracing for the Default instance.

  What parameters or values must I enter in the Server Side Trace script so it will trace the correct sql server instance? I google all over and nothing is found for this topic.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737424

  More actions

  May 15, 2008 at 2:37 pm

  #816142

  If you ran the stored procedures to create the trace on the named instance, it will run there. If you start Profiler, you have the option to connect to a particular instance when you define the trace.