Home Forums SQL Server 2005 Administering How to Create and Start SQL Server Trace Automatically RE: How to Create and Start SQL Server Trace Automatically

  • Lowell (6/3/2009)


    ALZDBA (6/3/2009)


    Attached you'll find a version I use for quick and dirty CPR-trace 😉

    ALZDBA the version you posted has all the CrLf stripped out, making it difficult to test, since we have to reformat manually; can you edit it or repaste it?

    You need to change the file extention !

    (just remove the .txt and keep the .SQL)

    If you then open it with ssms, it will be formatted OK.

    (I downloaded it from this thread, removed the .txt and it appeared ok in SSMS)

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me