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.