bpflanzer (4/26/2010)
I've seen this before- I'd bet your server isn't registered as "local"Try selecting from master.Sys.servers- (select * from master.sys.servers)
you're local servername should be server_id= 0
if it's not- I think you need to drop and readd
exec sp_dropserver 'myserver'
exec sp_addserver 'myserver',local
Good luck
Ben Pflanzer
Its a named instance in the server. Server id column has value as 1.