It's very difficult to select each and every database and search for the table from sys.tables something look like below
Select * from sys.tables where name like '%TableName_Here%'
What if you don't know the exact database, do you search all the databases to find the table?
if your database server has 100 database's then it will be a very tedious task for you to select a database and search so to avoid such pain below is the procedure you can execute this procedure in any of the databases and execute the procedure by giving the table name as a parameter.
