invalid column name

[robert030975]

I need to identify where this column could be, I have checked in the syscolumns but did not find it as a result I am now having to manually check each view and sp that could use the column so I can transfer the 2000 database to my new SQL 2005 machine.



In 2k Is there an easier way to identify this coloumn by some sort of search??

 

[ptheriault]

Check the INFORMATION_SCHEMA views.

For example to find a column in stored procedures

SELECT *
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION like '%yourcolumn%'

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[robert030975]

Cheers Paul


Found it was a SP!