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 MoreSQL Server Education (by the geeks, for the geeks)
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 MoreOver 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 MoreOne 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 MoreIts 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 MoreHi 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