How to Find a Stored Procedure in all the Databases?

When working with MS SQL Server sometimes you need to find a stored procedure in the databases and all that you know is the name of the stored procedure that your teammate told you that he had used but couldn’t remember in which database it was. All the information about the stored procedures created is saved in the master database. So, if you have access to the master database, you can run the following query to get information about the stored procedure.

select * 
from 
   sys.procedures 
where 
   name like '%name_of_proc%'

This will tell you in which schema you will find the stored procedure. Even, if you want to look into the code you can do so by running the following query.

select text 
from 
    syscomments c
    inner join sys.procedures p on p.object_id = c.id
where 
    p.name like '%name_of_proc%'

The text field contains the code of the stored procedure.

Let me know in the comments if you find this helpful or if you have any other ways to find the stored procedures.

Windows 8.1 update is now available to download

Today’s the day: October 17th, the day Microsoft starts rolling out Windows 8.1. And right now, the minute this post first went live, is 7AM ET, the exact minute the OS update will start appearing in the Windows Store as a free download. Don’t have a Windows 8 device? You can still install 8.1 on a Win 7 machine; you just won’t get the update for free. For folks using Windows 7, you’ll pay the same price Microsoft was already charging for Windows 8: $120 for the standard version, and $200 for Windows 8.1 Pro. Additionally, Microsoft will also be selling so-called full-version software, allowing you to install the OS on a machine that isn’t already running Windows. At any rate, if you’ve already got a Windows 8 device in hand, we suggest you hit up the source link below to take advantage of the free download. Or, if you’re a weirdo, you can also buy a boxed copy in a retail store. We won’t judge. Either way, you’re going to want to revisit our epic preview breaking down everything you need to know about the new features and apps that come with 8.1.

Exit mobile version