SELECT
@@SERVERNAME AS ServerName,
SERVERPROPERTY('ServerName') AS ServerPropertyName,
SERVERPROPERTY('MachineName') AS MachineName,
SERVERPROPERTY('InstanceName') AS InstanceName,
DB_NAME() AS CurrentDatabase;
به ترتیب :
NULL است.اول وضعیت را ببین:
SELECT
@@SERVERNAME AS RegisteredName,
SERVERPROPERTY('MachineName') AS MachineName,
SERVERPROPERTY('ServerName') AS ServerName;
EXEC sp_dropserver 'OLD-PC';
EXEC sp_addserver 'NEW-PC', 'local';
بعد سرویس SQL Server را Restart کن و دوباره بررسی رو انجام بده.




