RE: Server Name Incorrect!
From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 02/15/05
- Next message: Tibor Karaszi: "Re: Server Name Incorrect!"
- Previous message: hecsan07: "Re: Simple query"
- In reply to: Jason: "Server Name Incorrect!"
- Next in thread: Tibor Karaszi: "Re: Server Name Incorrect!"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 15 Feb 2005 07:49:01 -0800
Hi
sp_dropserver @server = 'TempServer'
GO
sp_addserver @server = 'Server', @local = 'local'
GO
Regards
Mike
"Jason" wrote:
> We got a new database server (also a Win2003 domain server). Got the
> databases over there fine, up and running fine. Ultimately we named it the
> same as the previous server to simplify some of our processes. That worked
> fine too, and it can be referenced on our intranet as "Server" via SQL,
> Windows, etc.
>
> HOWEVER, some processes mysteriously don't work, like Agent-driven backups,
> etc. Ultimately we determined that in the Master database, the 'sysservers'
> table refers to the server as "TempServer" (the temporary name we assigned
> while setting everything up). How do we change the name in the system table
> so that the new name applies and the temporary name is totally gone??? I
> assume there's some SP but I'm not sure. Thanks.
>
>
>
- Next message: Tibor Karaszi: "Re: Server Name Incorrect!"
- Previous message: hecsan07: "Re: Simple query"
- In reply to: Jason: "Server Name Incorrect!"
- Next in thread: Tibor Karaszi: "Re: Server Name Incorrect!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
