February 22, 2008 at 3:57 am
How is possible to update the data in the view sysservers!?
It is me not allowed as "sa" to delete any inserts with sp_dropserver.
I get the message that the server that I like to drop has any active connections yet.
With sp_addlinkedserver I could add the new servername.
In the view sysservers I have now 3 insertions: OLDSEREVER, repl_admin (pointed to the OLDSERVER) and NEWSERVER.
February 22, 2008 at 4:26 am
Hi
can u explain what you are trying to do.
The error message means that the server (linked server i presume) is being accessed. i.e its in user.
"Keep Trying"
February 22, 2008 at 4:38 am
Hello,
After a hardware crash I took the old file "distribution" and copied it to a new server where I have already an installed SQL Server 2005. When I try to delete the old "distributor" or to disable it, I get the message that the program needs the name for the OLDSERVER.
I tried to make sp_dropserver 'OLDSEREVER' but I get the message that the OLDSERVER is connected yet to other applications.
After a sp_addlinkedserver 'NEWSERVER' I could add the new server.
So that at this time I have 3 inserts in the view "syssservers". See above.
I can not delete the obsolet inserts.
Due to the database 'distribution' is a system database, I could not delete it.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply