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