Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 version of SQL server

Author  Topic 

sqlpavan
Starting Member

20 Posts

Posted - 2011-11-23 : 11:22:58
how come we know the version of SQL server by using SQL Command...

pavan444

chris_cs
Posting Yak Master

223 Posts

Posted - 2011-11-23 : 11:29:51
SELECT @@VERSION

----------------------------
Junior DBA learning the ropes
Go to Top of Page

vikki.seth
Yak Posting Veteran

66 Posts

Posted - 2011-11-23 : 14:34:36

You can try this as well..
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Go to Top of Page
   

- Advertisement -