August 28, 2002 at 2:13 pm
I use Sql 2K : Copy Sql Server Objects task to copy stored procs from our Test environment to our Prod environment. When I execute the task I get the error
[Microsoft][ODBC SQL Server Driver][SQl Server] Invalid column name 'suid'
repeated three times.
Help!
TIA,Bill
August 28, 2002 at 2:48 pm
DO you know where the suid reference is coming from? Is there a table or view referenced on test that is not that way in prod? If not try watching with profiler to see if you can catch the events that lead up to that message.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
August 29, 2002 at 4:59 am
It sounds like you have a table on one server with this field in it but on the new server this field is not present. There is a product called SQLComapre that could help you find out the differences between you SQL schemas.
You can have a lot of problems if you have linked server referenced in a stored procedure and the linked server does not exist on the server you are trying to move to.
Bruce Szabo, MCSE+I, MCDBA, MCSD
Bruce Szabo, MCSE+I, MCDBA, MCSD
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply