Home › 2016 › May
Month: May 2016

SQL Server – Set Max Memory

Posted on by Raju V Posted in SQL Server, Technology — No Comments ↓

SQL Server – Set Max Memory MSDN Link on Changing Max Memory /* (4 row(s) affected) Msg 15123, Level 16, State 1, Procedure sp_configure, Line 62 [Batch Start Line 0] The configuration option ‘max server memory’ does not exist, or…

Read more ›

SQL Server Internal Versions

Posted on by Raju V Posted in AWS RDS, SQL Server — No Comments ↓

SQL Server Internal Versions SQL Server Versions Database Internal Versions and Compatibility Levels Useful Query SELECT SERVERPROPERTY(‘ServerName’) ‘ServerName’ , @@VERSION ‘@@version’ , SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’) ‘ComputerNamePhysicalNetBIOS’ , SERVERPROPERTY(‘MachineName’) ‘MachineName’ , SERVERPROPERTY(‘InstanceName’) ‘InstanceName’ , SERVERPROPERTY(‘IsClustered’) ‘IsClustered’ , SERVERPROPERTY(‘BuildClrVersion’) ‘BuildClrVersion’ , SERVERPROPERTY(‘Collation’) ‘Collation’ ,…

Read more ›

Top