Thanks for the initial help. I have now got a clear picture of what to do. The requirement goes like this.

Test environment - We have 15 user databases to be...

Its basically a storage issue and they are not in a position to expand the LUN being a UAT box

Have seen all possibilities and there is nothing suspicious found from SQL end, but the client wants to know the tables which are accessed now 🙁

Hi:)..

This is an old app. There are no blocking's on the server but i could see few active connections on a database. But how to identify the particular table being...

Thanks Grasshopper. I am planning to register all the servers in SSMS but looking out for a query which does the same

Thank you. Seems like I am heading in the correct direction with your help. I have now queried msdb.dbo.sysjobs. But how to link it with sysjobschedules then link that to...

Yes Antony. The name of the job remains same across all the servers

Thanks for the reply Antony. But that will be a tedious task to go to the job and check the schedules for all the databases across many servers. Hence looking...