question

aleogho avatar image
aleogho asked

truncated data

Investigate the cause of table blah_blah being truncated, not deleted on a daily basis. The time it happened this morning was after 2.44 am CT and 12noon CT. I ran a trace for 1hour which started at 2.20 am CT and saved it to a table in my local database. how do i filter the truncated information from the trace table with a where clause?
msdbms sql
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
Simply select on the `TextData` column select * from YourTable where textdata like '%truncate%'
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.