Scan stored procedures in all databases

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by TomBrattin » Scan stored procedures in all databases

Scan stored procedures in all databases

Rate Topic

Display Mode

Topic Options

Author

Message

TomBrattin

Posted Saturday, September 29, 2007 6:18 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 4:58 PM
Points: 1,827, Visits: 8

Comments posted to this topic are about the item Scan stored procedures in all databases

Post #404363

Ninja's_RGR'us

Posted Saturday, September 29, 2007 6:58 AM

SSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:02 PM
Points: 21,376, Visits: 9,584

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 »

Permissions