How to know the SQL Server Version ?

added by jacobsebastian
4/15/2010 6:01:57 AM

1 Kicks, 66 Views

In order to know the SQL Server and Edition details you would be possibly looking at the SQL Server properties and find out the details. Occasionally it might be needed to check the same as part of a job / or a script, you need to query the SQL Server for this info. In order to do this you can use @@Version to retrieve the installation information of SQL Server.