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

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 INNER JOIN …

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 procedures. I know I …

Apr 7, 2011 · I need to check when function was changed last time. I know how to check creation date (it is in function properties window in SQL Server Management Studio). I found that in SQL Server 2000 …

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 inside of the …

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.

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 the Object …

I am new to SQL Server. I am logged into my database through SQL Server Management Studio. I have a list of stored procedures. How do I view the stored procedure code? Right clicking on the sto...

Mar 12, 2015 · 24 This code copies all stored procedures in the Master database to the target database, you can copy just the procedures you like by filtering the query on procedure name. @sql is defined …

0 I've used these in the past: Searching all user stored procedures for a table name Search and replace SQL Server data in all columns of all tables In this particular case, where you need to replace a …