October 23, 2002 at 11:57 am
In sql 7 there were several systems table containing a "suid" column. We are converting our databases to Sql 2K where this field no longer exists!
How can I determine which stored procs reference to this column? (Some sort of text search)
TIA,
Bill
October 23, 2002 at 1:31 pm
try select * from syscomments where text like '%suid%'
Steve Jones
October 23, 2002 at 2:22 pm
if you can still access them on sql7 you can use sysdepends to determine which ones, the id column is the id of the view, function or SP, the depid is the id of the table, view, SP that is dependant and the depnumber is the colid from syscolumns of the column dependant on
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply