Posted by Erland Sommarskog on 06/02/05 00:35

(andyjgw@gmail.com) writes:
> Client application now connects, I can't see any problems, but there
> have been some strange anomalies in satellite applications today. All
> have been bounced to see if it's just a change they needed to notice,
> to no avail.
>
> Was that an OK operation to have done, or is there something just about
> to bite me when I'm not looking?

This might not really the right way to do it. Then again it sounds
sound to me. Without knowing about the anomalies, it's difficult to
say what might be wrong.

One thing to check though is @@servername. If it's wrong, drop the
name with sp_dropserver. If NULL, add it with sp_addserver with the
"local" parameter. See Books Online for details.

This KB article may be helpful:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
(although you probably should have seen it earlier!)


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]