Wednesday, March 7, 2012

Could not find server 'x' in sysservers

SQL2005:
Updating some tables in a database works fine. Updating others in the
same database fails with
"Could not find server 'picasso' in sysservers".
How come it goes for some and not others?
"picasso" is our old server that doesn't exist anymore. It was holding
a SQL-2000 that has been upgraded to SQL-2005...?
Thanks in advance for any help.
Regards /SnedkerIs it possible that you have a trigger on those tables that tries to
insert into 'picasso' ?
run EXEC sp_helptrigger TableName to find out if there are triggers on
those tables
Denis the SQL Menace
http://sqlservercode.blogspot.com/
Morten Snedker wrote:
> SQL2005:
> Updating some tables in a database works fine. Updating others in the
> same database fails with
> "Could not find server 'picasso' in sysservers".
> How come it goes for some and not others?
> "picasso" is our old server that doesn't exist anymore. It was holding
> a SQL-2000 that has been upgraded to SQL-2005...?
>
> Thanks in advance for any help.
>
> Regards /Snedker|||On 7 Jun 2006 05:56:57 -0700, "SQL Menace" <denis.gobo@.gmail.com>
wrote:
Aaaahaaaaaaaaaaaaaaaaaaa ! :-)
Actually I already changed some tables for that exact same thing, but
seems like I didn't get all the way around. Thanks for getting me back
on track! ;-)
Regards /Snedker
>Is it possible that you have a trigger on those tables that tries to
>insert into 'picasso' ?
>run EXEC sp_helptrigger TableName to find out if there are triggers on
>those tables
>
>Denis the SQL Menace
>http://sqlservercode.blogspot.com/
>Morten Snedker wrote:

No comments:

Post a Comment