DatabaseID in a trace

[williamkremer]

I'm running a trace on a server to monitor which databases on the server are being used currently. In my trace columns I have DatabaseName and DatabaseID. Wouldn't you know, the databasename column remains empty throughout but databaseID column is populated by numbers (8, 2, 15, etc) When I run select object_id ('anydatabase') it returns NULL for each database. Is there a way to translate those databaseID's in the trace into which database it is using? Thanks --

"You cannot hold a torch to another man's path without brightening your own"
Best regards,
Bill

 

[SQLDenis]

yep use DB_NAME ( database_id )


select DB_NAME(8)


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[williamkremer]

Bingo! Thank you very much!

"You cannot hold a torch to another man's path without brightening your own"
Best regards,
Bill