sql2008安装后服务器改名造成名称不一致
- WBOYOriginal
- 2016-06-07 17:43:291174browse
用select @@servername和select serverproperty('servername')一查看服务器名是否一致 如果不一致，则以serverproperty('servername')为准 解决办法： exec sp_dropserver @server = ‘服务器名’ exec sp_addserver @server = ‘服务器名’, @local = 'LOCA
用select @@servername和select serverproperty('servername')一查看服务器名是否一致
如果不一致，则以serverproperty('servername')为准
解决办法：
exec sp_dropserver @server = ‘服务器名’
exec sp_addserver @server = ‘服务器名’, @local = 'LOCAL'
重启sql2008数据库服务，香港虚拟主机，香港空间，后再次检查是否一致 ，网站空间
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article： SQLServer导出sql文件，导出表架构和数据Next article： SQLSERVER2005各个版本和组件