sp_addlinkedserver SQL 2008

Test Server for PWHOT1 VM clone and change computer name and SQL Server name. but DBLink Connect still old.


select name from sys.servers
select * from sys.servers

sp_dropserver 'PWHOTRPT'
GO

-Add DB Link Server
EXEC sp_addlinkedserver
@server = 'PWHOTRPDRATEST', --Server Name
@srvproduct = 'MS SQL',    <------  on other web said 'SQL Server' , but cannot execute
@datasrc = 'PWHOTRPDRATEST' , --Server IP or Hostname
@provider = 'SQLNCLI'

select name from sys.servers
select * from sys.servers

https://dotblogs.com.tw/puma/2009/02/05/7038

http://tsuozoe.pixnet.net/blog/post/22417837-sp_addlinkedserver-%E3%80%81-sp_dropserver-%E4%BD%BF%E7%94%A8%E6%96%B9%E6%B3%95-

https://stackoverflow.com/questions/35799905/could-not-find-server-server-name-in-sys-servers-sql-server-2014