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 |
|
Lucky
Starting Member
10 Posts |
 Posted - 2008-03-27 : 08:16:55
|
| Hi, I am trying to get Database name in Trace files, I can see DBID and I can get DB name through ID, but can I get DB name in trace files also. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-03-27 : 08:19:43
|
Check "Show all column" in trace properties and then check DatabaseName.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
Lucky
Starting Member
10 Posts |
Posted - 2008-03-27 : 08:57:32
|
| I did this to add the DatabaseName , even I add all the column, but when I run I shows me all the activities except DatbaseName, I can see DB ID, but I can't see DatabaseName in Trace Files, also I want to know, how can I Hide my running trace file from the other person ?We can be Knowledgeable with other mens Knowledge, but we can't be wise with other mens wisdom. |
|
|
|
Lucky
Starting Member
10 Posts |
Posted - 2008-03-27 : 09:19:18
|
| Actually when I close the Trace file windows, SQL Monitoring activities stops, is there any way if I close the trace windows, SQL Events history remains working in the background ???______________________________________________________________________________________"We can be Knowledgeable with other mens Knowledge, but we can't be wise with other mens wisdom" |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-27 : 23:10:52
|
| Then you need start trace with system sps. |
|
|
|
|
|
|
|
|
How to get Database Name in Trace Files?