Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag System Stored Procedure Rss

   Items 1 to 2 of 2   

sp_msforeachdb: Improving on an Undocumented Stored Procedure

Have you ever wanted to run a query across every database on a server with the convenience of a stored procedure? If so, Microsoft provided a stored procedure to do so. It’s unreliable, outdated, and somewhat obfuscated, though. Let’s improve on it!  Read more...
By Edward Pollack 2014/12/01 | Source: | Category: sp_msforeachdb
Rating: |  Discuss |   Briefcase | 9,575 reads

How to get list of Stored Procedure

You can use following stored procedure with four optional input parameters to get a list of all stored procedures in the current environment.  Read more...
By Tariq 2008/08/11 | Source: | Category: system stored procedure
Rating: |  Discuss |   Briefcase | 839 reads
   Items 1 to 2 of 2   
databases (1)    
deprecated (1)    
dynamic sql (1)    
sp_msforeachdb (1)