Database Scripts

  If you wanna find on which Data File your SQL Server Table is on, use the following query by providing the table name you are looking for:

 

This T-SQL script will help you find an object in your Server. It will go over all of your databases and see in which database you have this object.

  • this is the poor man RedGate :).