Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DatabaseID in a trace

Status
Not open for further replies.

williamkremer

Programmer
Oct 27, 2005
61
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
 
Bingo! Thank you very much!

"You cannot hold a torch to another man's path without brightening your own"
Best regards,
Bill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top