Stored procedures in can accept input parameters and return multiple values of output parameters; in SQL Server, stored procedures program statements to perform operations in …

What query can return the names of all the stored procedures in a SQL Server database If the query could exclude system stored procedures, that would be even more helpful.

Feb 5, 2013 · I want to search a text from all my database stored procedures. I use the below SQL: SELECT DISTINCT o.name AS Object_Name, o.type_desc FROM sys.sql_modules m …

Mar 3, 2016 · 29 I once needed the lines of the stored procedures to be able to trace whether I have a reference to some function, procedure or table, or sometimes to try to find something …

Apr 7, 2011 · 9 In latest version (2012 or more) we can get modified stored procedure detail by using this query sql

Mar 25, 2011 · I generated script from old database, created a new database and imported all data from old database. So far so good, however, no user has execute rights for stored …

Search and replace SQL Server data in all columns of all tables In this particular case, where you need to replace a specific string across stored procedures, the first link is probably more …

When should I use a function rather than a stored procedure in SQL, and vice versa? What is the purpose of each?

Aug 14, 2013 · 47 Stored procedures aren't stored as files, they're stored as metadata and exposed to us peons (thanks Michael for the reminder about sysschobjs) in the catalog views …

From the Object Explorer Details window in SSMS, open the stored procedures folder. Select all the objects (you can multi-select from this window, which is pretty much the only purpose of …