What's the security settings on the linked server "srvr1"?
(In object explorer, Server object -> Linked servers, right click that linked server, choose properties, go to the security tab)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability