Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Stairway to Server-side Tracing - Step 2: Creating a SQL Trace Using T-SQL (Stairway Series) Expand / Collapse
Author
Message
Posted Friday, November 8, 2013 6:40 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 6:00 AM
Points: 54, Visits: 289
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.


Post #1512646
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse