Shulou(Shulou.com)06/01 Report--

Use master go select @ @ servername,serverproperty ('servername')-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 ELSE PRINT 'instance name is the same as hostname No need to modify!' ! [] (https://cache.yisu.com/upload/information/20200311/41/171155.jpg?x-oss-process=image/watermark,size_16,text_QDUxQ1RP5Y2a5a6i,color_FFFFFF,t_100,g_se,x_10,y_10,shadow_90,type_ZmFuZ3poZW5naGVpdGk=)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.