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



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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, June 17, 2009 8:04 AM
Points: 271, Visits: 55
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 »


Permissions Expand / Collapse