Re: Changing SQL Server Name

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 09/09/04 

Date: Thu, 09 Sep 2004 12:10:56 -0600

Oh and the jobs. You can script out your jobs and then go through the
script and change the server name and replace the jobs with the new
jobs you have just scripted.
The sysjobs table has the originating_server column which has the
server name value stored in it. It will be referencing the old server
name when you rename the server.

-Sue

On Thu, 09 Sep 2004 09:33:34 -0700, don larry <donlarry17@hotmail.com>
wrote:

>Greetings,
>
>I have an application that runs on SQL Server XXXX. I want to change the
>name of the server to YYYY.
>
>Other than changing references within the application, is there anything
>else I need to do because of the Server name change?
>
>Platform: Win 2000 Server/SQL Server 2000
>
>Thanks in advance,
>Don
>
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • CUPS problem printing pictures is very slow
    ... all jobs) and everything is working very well, ... # Server name ... # Browse order (BrowseOrder) ... # Whether or not to use implicit classes. ...
    (Debian-User)
  • CUPS problem printing is slow
    ... all jobs) and everything is working very well, ... # Server name ... # Browse order (BrowseOrder) ... # Whether or not to use implicit classes. ...
    (Debian-User)
  • Re: How to send E-mail without an external SMTP server ?
    ... you're sending email using external server. ... I want to find a way to send email without an external smtp server. ... Actually I was writing a script that can submit jobs automatically on a remote server. ... I should not submit the jobs all at once, because this will take up all resources of the server. ...
    (comp.lang.python)
  • Re: strange problem with send() and recv()
    ... > I try to write a simple tcp based job queue server. ... > get commands from a client and store them in a queue. ... > The client can query the server about the jobs currently queued. ...
    (comp.lang.c)
  • Re: Deleting all jobs in remote print queue
    ... remote machine is Server 2003 or XP. ... We have situations in which we need to delete all print jobs, ... print queues, via a script. ...
    (microsoft.public.windowsxp.print_fax)