Prev: basic join question
Next: A rather basic question I am sure...
From: Thomas on 19 Jun 2010 12:20
John,

You did just became a hero (one of many though).

thanks.

"Neil W" wrote:

> When running this:
> master.dbo.sp_add_log_shipping_primary_database
>
> I get the following error:
> Msg 14262, Level 16, State 1, Procedure sp_add_jobserver, Line 88
> The specified @server_name ('oldname') does not exist.
>
> Note that the machine name for server 'oldname' was changed to 'newname'
> and rebooted. As expected, @@servername and serverproperty('servername')
> return 'newname'
>
> However, somehow oldserver is getting added to the job and, of course, it is
> coming back as not existing.
>
> What has to be done to the SQL instance to get it to recognize a machine
> name
> change?
>
> I am using SQL 2005 (default instance) on Windows 2003 Server, all updates
> applied.
>
> Thanks.
>
>
>
>
> .
>
 | 
Pages: 1
Prev: basic join question
Next: A rather basic question I am sure...