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 |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
 Posted - 2001-03-07 : 09:58:07
|
| Is this a bug or just the way SQL Server works?I have a trace setup to return only events from DB ID 20. I have tested the trace and it works.This is the curious part: I open EM and select the same server and expand a different DB, say DB ID 17. I then choose stored procedures and then double click one of the SP's. Doing this returns data in my trace as DB ID 20, even though I have done this in a different DB. If I do so in DB 20 then it returns a lot more than 1 line in my trace.Does SQL Server run a select on all the databases when you open an SP?DanielSQL Server DBA |
|
|
|
|
|
Curious behavior of SQL Profiler in a trace