AndyJarrett

Search all MSSQL databases on a server for a table

I use MSSQL/T-SQL just enough to be dangerous with it. Though the other day I knew I had a table in one of the many dev databases but could I find it ..... no!

This script loops through ALL databases on a server looking for table called "tableNameYouAreSearchingFor"