DBA

SQL Server Information

SQL Server Information from a script

SQL Server Information from a script. SQL Server has a lot of useful information that you need to administrate or develop solutions. Here is a great SQL Script to find out information about your SQL Server Instance and operating system. — Get selected server properties SELECT SERVERPROPERTY(‘MachineName’) AS [MachineName], SERVERPROPERTY(‘ServerName’) AS [ServerName], SERVERPROPERTY(‘InstanceName’) AS [Instance], SERVERPROPERTY(‘IsClustered’) …

SQL Server Information from a script Read More »