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

Script to Find Locations of Specified Column Expand / Collapse
Author
Message
Posted Sunday, September 30, 2007 6:49 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 14, 2007 1:40 PM
Points: 42, Visits: 1
Comments posted to this topic are about the item Script to Find Locations of Specified Column


Post #404798
Posted Sunday, September 30, 2007 7:31 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, December 13, 2013 4:35 AM
Points: 386, Visits: 211
Haven't looked at this very carefully but it doesn't seem to cater for entries that are split across pages in syscomments.

Would also maybe return false entries if one statmet has a select * in it and another references the table.
And does it handle the various formats that could be used for a select statement?



As I said I only glanced at it so could be wrong.



Cursors never.
DTS - only when needed and never to control.
Post #404802
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse