Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Scan stored procedures in all databases Expand / Collapse
Author
Message
Posted Saturday, September 29, 2007 6:18 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, September 24, 2013 4:16 AM
Points: 1,828, Visits: 9
Comments posted to this topic are about the item Scan stored procedures in all databases


Post #404363
Posted Saturday, September 29, 2007 6:58 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, August 28, 2014 4:00 AM
Points: 21,397, Visits: 9,612
This doesn't take into consideration that the code string in syscomments i split after each 4000 characters set.

You need to do a left join on colid + 1 and do the like match on the whole concatenated rows.

Of course, we don't have that problem in 2k5 with the new system views.
Post #404383
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse