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