What do consultants do when they come across any new instance of SQL Server? Well, their very first question is what version of SQL Server is it? The reason is simple – SQL Server is a very vast product and each version of the product have new features released and old features deprecated. Many consultant even remembers service pack and features released in it.
Well, there are multiple ways to know the version numbers of the SQL Server. In this sixty second video we will see a neat trick where we will quickly find the version number of SQL Server.
Let us see the same concept in following SQL in Sixty Seconds Video:
Related Tips in SQL in Sixty Seconds:
- Get Server Version and Additional Info
- Get All the Information of Database using sys.databases
- Script to Find SQL Server on Network
- Version Information and Additional Information – Extended Stored Procedure xp_msver
What would you like to see in the next SQL in Sixty Seconds video?
Reference: Pinal Dave (https://blog.sqlauthority.com)
Great tips. I did not know this “SERVERPROPERTY”.
I want to add the old extended procedure: [xp_msver].