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

Content with tag syscomments Rss

   Items 1 to 3 of 3   
 

Potential Issue with Re-Naming Stored Procedures

In this article Mohammad Meimandi explains an issue faced while using SQL-DMO to copy database objects.  Read more...
By Mohammad Meimandi 2010/10/07 | Source: SQLServerCentral.com | Category: syscomments
Rating: |  Discuss |   Briefcase | 7,822 reads

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 | 763 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 | 985 reads
   Items 1 to 3 of 3   
 
Tags
dependencies (1)    
functions (1)    
procedures (1)    
sp_rename (1)    
sql server 7 (1)    
sql-dmo (1)    
views (1)