Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: SQLServerCentral.com | Category: sp_msforeachdb
Rating: |  Discuss |   Briefcase | 8,662 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: SQLServerCentral.com | Category: system stored procedure
Rating: |  Discuss |   Briefcase | 799 reads
   Items 1 to 2 of 2   
 
Tags
databases (1)    
deprecated (1)    
dynamic sql (1)    
sp_msforeachdb (1)