转贴的:1. 7.0 的话, 放入安装光盘, 执行安装程序, 它会自动修复
2. 2000 改名不会影响启动
3. 改名后要把服务器名调整正常, 代码如下, 完成后要重新启动计算机:DECLARE @server sysname
SELECT @server=CAST(SERVERPROPERTY('servername') as sysname)IF EXISTS(
SELECT * FROM master.dbo.sysservers WHERE srvname=@server)
EXEC sp_dropserver @server
EXEC sp_addserver @server,'local'4. 要重新设置job 的originating_server ,代码如下:USE msdb
GOEXEC sp_configure 'allow updates',1 RECONFIGURE WITH OVERRIDE
GOUPDATE sysjobs SET
originating_server=CAST(SERVERPROPERTY('servername') as sysname)
GOEXEC sp_configure 'allow updates',1 RECONFIGURE WITH OVERRIDE
2. 2000 改名不会影响启动
3. 改名后要把服务器名调整正常, 代码如下, 完成后要重新启动计算机:DECLARE @server sysname
SELECT @server=CAST(SERVERPROPERTY('servername') as sysname)IF EXISTS(
SELECT * FROM master.dbo.sysservers WHERE srvname=@server)
EXEC sp_dropserver @server
EXEC sp_addserver @server,'local'4. 要重新设置job 的originating_server ,代码如下:USE msdb
GOEXEC sp_configure 'allow updates',1 RECONFIGURE WITH OVERRIDE
GOUPDATE sysjobs SET
originating_server=CAST(SERVERPROPERTY('servername') as sysname)
GOEXEC sp_configure 'allow updates',1 RECONFIGURE WITH OVERRIDE
GO
sp_addserver new_name, local
GO如果计算机上具有 SQL Server 的多个实例,请按以下方式运行存储过程以更改 sysservers 系统表信息:sp_dropserver old_servername\instancename
GO
sp_addserver new_servername\instancename, local
GO