Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlbug
Posting Yak Master
201 Posts |
 Posted - 2014-07-29 : 17:17:28
|
| I'm trying to troubleshoot an issue and noticed that the database name under DatabaseName column shows up as master instead of the actual name of the database. I know master keeps information on the user databases.But I'm just curious why the name of the master database should come up here.Thanks, |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-29 : 17:21:13
|
| It's because that's what the spid connected to. You can't rely on that column, though I do include it in my traces.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
sqlbug
Posting Yak Master
201 Posts |
Posted - 2014-07-29 : 17:54:00
|
| Thanks Tara. |
|
|
|
|
|
|
DatabaseName in Profiler