MBCDN

Dies ist eine alte Version des Dokuments!

Microsoft SQL Server ist ein von Microsoft entwickelter Datenbank Server.

Query to CSV Export

SELECT @@SERVERNAME         AS ServerName,
       SERVERPROPERTY('MachineName') AS MachineName,
       SERVERPROPERTY('InstanceName') AS InstanceName,
       SERVERPROPERTY('Edition') AS Edition,
       SERVERPROPERTY('ProductVersion') AS ProductVersion,
       SERVERPROPERTY('ProductLevel') AS ProductLevel;

Get-Service | Where-Object { $_.Name -like "MSSQL*" }

Server umbenennen

Default Instance

SELECT @@SERVERNAME; 
 
EXEC sp_dropserver 'OldServerName';
GO

EXEC sp_addserver 'NewServerName', 'local';
GO

-- SQL-Server-Dienst neu starten

Named Instance

SELECT @@SERVERNAME;

EXEC sp_dropserver 'OldServerName\InstanceName';
GO

EXEC sp_addserver 'NewServerName\InstanceName', 'local';
GO

-- SQL-Server-Dienst neu starten

Downloads