cats
jamesalleniwd
shuming
xiaohai
sunnylovey
adrienbrody
normancohn
daniellevan
rerqr
iaiyhadlda
habeb1
addisonjame01
yasmine1101
dellsony
jacobsebastian
toponscom
pinaldave
akkushaus
lapss321
Lenovo13
http://ozziemedessql.blog...
mayluobatty
ashishgilhotra
abcdee
AdaTheDev
lauriesteve
http://ghemant.myopenid.com/
Here’s another use for the information captured by the default trace. Ever wonder what session created the tables that exist in tempdb? Well you can find it using the default trace and the sys.objects view in tempdb. Any time an object is created in a database, EventClass 46 (Object:Created) is captured in the trace output of the DMV. By scanning the trace files for a matching ObjectID that was created 100 ms before or after the objects create_date with DatabaseID = 2 (tempdb) you can match the objec...
|
1
kudos |
|
||||
sa
No comments yet, be the first one to post comment.