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 |
|
denis_the_thief
Aged Yak Warrior
596 Posts |
 Posted - 2010-02-10 : 10:15:00
|
| We have some Procs that raise error messages. They appear in the SQL Server Logs. But is there any way to determine which databases they originated from? (ie. from which database is the stored procedure that wrote the message) |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-10 : 11:57:52
|
| You could probably include the name of the DB in the error messages their raise; you could also use SQL Profiler to monitor the SQL requests which may help - (but AFAIK not if the Sproc in question is itself called from another Sproc, rather than directly from the end user / application / scheduled task) |
 |
|
|
|
|
|
Log question