Home Forums SQL Server 7,2000 General *** HUGE SQL Server Problem *** =( RE: *** HUGE SQL Server Problem *** =(

  • May 10, 2014 at 4:36 pm

    #1712420

    1. Open the SQL Profiler tool

    2. Connect to the server

    3. Check Show All Events and Show All Columns

    4. Deselect any pre-selected events

    5. Expand Objects

    6. Select Object:Altered event

    7. Go back to the General tab

    8. Check Save to File

    9. Set the file path and name

    10. Start the trace running

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]