Viewing 4 posts - 1 through 4 (of 4 total)
Thanks for that. The reason I am confused is that my actual servername (which is correctly returned by using SERVERPROPERTY('servername')), differs from the DNS name used for the server.
In my...
July 4, 2007 at 4:30 am
Yeah, I did include the @local parameter. this has added the servername to syservers but has not resloved the DTS auth problem unfortunately. beginning to suspect it may be a...
March 26, 2007 at 1:48 am
Well using sp_addserver has added the server to the syservers table but @@servername still brings a result of NULL. Does the service require restart to update @@servername?
March 23, 2007 at 5:03 am
Well that did occure to me, but all the DTS packages that are failing were local to the problematic server, not connecting to any other. Why should the server require...
March 23, 2007 at 3:23 am
Viewing 4 posts - 1 through 4 (of 4 total)