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 |
|
kbk
Starting Member
34 Posts |
 Posted - 2009-05-28 : 15:21:58
|
| I have a list of jobs in application server which are being used by the application team..the jobs access the databases from the production server(only system databases are present in the application server).i wish to know which of the jobs in the application server are using the databases in production server.Please could someone suggest a way to find this out...???If it can be done from scripting the job, please let me know how it can be found out fromt he script?thankyou!!PVK |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-05-28 : 23:32:27
|
| Trace it with SQL profiler. |
 |
|
|
|
|
|
FINDING DATABASE USED!!!!!!