Smart Tips About How To Check Sql Database Version
In mysql, the @@version variable contains the server version number.
How to check sql database version. Using the select @@version function or using the serverproperty function. Find out what it is. Select @@ version as version.
All i'm doing is looking at a property (skuname) of. Just an option using the registry, i have found it can be quicker on some of my systems: It may also include a suffix with configuration or.
Connect to the instance of sql server, and then run the following query:. Connect to your sql server instance by executing this command: This can be done through wmi (accessed through powershell in my below example).
Following are possible ways to see the version: You can run this function. Using system extended stored procedure.
Second, run the following command: The @@version function is a configuration function, which returns system and build information for the current installation of sql server. And you'll get a result like: