Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag syscomments Rss

Search for any content tagged syscomments

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 2 of 2   
 

Find all Procedures, Views, Functions that have been renamed

Find all Procedures, Views, Functions that have been renamed with sp_rename where syscomments does not match.  Read more...
By David Hay 2009/08/17 | Source: SQLServerCentral.com | Category: sp_rename
Rating: (not yet rated) |  Discuss |   Briefcase | 758 reads

Tables referenced by a stored proc (2000)

This should find all tables referenced by an sp. It uses syscomments and hence has a wrap 'issue'.  Read more...
By David McKinney 2008/12/30 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 983 reads
   Items 1 to 2 of 2