[Script Of Jun. 05] Find the SQL Server databases that contain a certain table or stored procedure

image

Jun.

05

image

image

Script Download:   
The script is available for download from https://gallery.technet.microsoft.com//Find-the-SQL-Server-5e53757b.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.

This T-SQL script will demonstrate how to find the SQL Server databases that contain a certain table or stored procedure.

Some people want to know if a table or stored procedure exists in databases or not and which database the table/ stored procedure is contained. So we provide this script to find out the result.

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery