Home Forums Article Discussions Article Discussions by Author Discuss content posted by Dan Guzman Stairway to Server-side Tracing - Step 2: Creating a SQL Trace Using T-SQL (Stairway Series) RE: Stairway to Server-side Tracing - Step 2: Creating a SQL Trace Using T-SQL (Stairway Series)

  • November 8, 2013 at 6:40 am

    #1665088

    majinbao (11/7/2013)

    Thank you very much for the post. great articles.

    the only information I can get is object:alert, but it doesn't tell me the TextData is null. I can not tell what happened to this database.

    any solution? thanks.

    The Object:Altered event does not expose the statement text. If you need the text data too, you can include the SQL:Statement Completed event, filtered accordingly (i.e. LIKE '%ALTER%'. The SQL:Statement Completed event can then be correlated with the Object:Altered based on TransactionID included in both events. Assuming you are leveraging the default trace for the Object:Altered event, a separate trace for the SQL:Statement Completed event will be needed.