sqlserver数据库如何修改实例名称

if serverproperty('servername') <> @@servername 
begin 
	declare @server sysname 
	set @server = @@servername 
	exec sp_dropserver @server = @server 
	set @server = cast(serverproperty('servername') as sysname) 
	exec sp_addserver @server = @server , @local = 'LOCAL' 
END
-- 增除了旧的任事器名
EXEC sp_dropserver 'C9FV63M3';
-- 加添新的处事器名
EXEC sp_addserver 'C9FV63M3两', 'local';

 SELECT serverproperty('servername') --管事器名称 
 SELECT @@SERVERNAME   --数据库真例名

<strong>use newname;</strong> 
DECLARE @table SYSNAME; 
DECLARE @schema SYSNAME; 
DECLARE @new_schema SYSNAME; 
<strong>SELECT @schema </strong><strong>= 'oldname' --本有属主
SELECT @new_schema = 'newname' --</strong><strong>新属主</strong>
DECLARE csr CURSOR FOR  
SELECT o.name, u.name FROM sys.objects o  
INNER JOIN sys.schemas u ON o.schema_id = u.schema_id  
WHERE o.type in( 'u','p','v','tf','fn','if') AND u.name = @schema  
OPEN csr; 
FETCH NEXT FROM csr INTO @table, @schema;  
WHILE @@FETCH_STATUS = 0  
BEGIN  
exec ('ALTER SCHEMA ' + @new_schema + ' TRANSFER [' + @schema + '].[' + @table + ']'); 
FETCH NEXT FROM csr INTO @table, @schema; 
END  
CLOSE csr  
DEALLOCATE csr ;