SQL Server 2016 – New SERVERPROPERTY properties
Hi Friends, I hope that most of us uses SERVERPROPERTY in SQL Server to collect various information about the Instance. I used SERVERPROPERTY most of the time when I got a …
Read MoreTag: SERVERPROPERTY
SQL Sever SERVERPROPERTY – The Unused Power
Over the years I have seen admins struggle when asked to provide SQL instance level information. They right click here and there and YES I was one of them till I …
Read MoreScript to find SQL Server version
One of the first things we do when inheriting a new SQL Server environment or when troubleshooting issues, knowing SQL Server version. There are different ways to get SQL Server information. …
Read MoreSQL Server Difference between @@SERVERNAME and SERVERPROPERTY(‘SERVERNAME’)
Its general understanding that SQL Server Difference between @@SERVERNAME and SERVERPROPERTY(‘SERVERNAME’) will return same values. But once I got a different values for both Select @@SERVERNAME Select SERVERPROPERTY(‘SERVERNAME’) were returning different …
Read MoreHow to get SQL Server Edition, Version related info?
Hi All, Today’s Question of the day is: How to get SQL Server Edition, Version related info? SQL Server build related info can be retrieved in no. Of ways, we’ll talk …
Read More