How to know sql server version through sql statment

Question

Post reply

How to know sql server version through sql statment

deba_20032004

Default port

Points: 1476
More actions
June 2, 2008 at 6:13 am

#121639

Dear Sir,
Plz help me the above topic

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

rajankjohn SSCertifiable Points: 5061 More actions · Answer 1

rajankjohn

SSCertifiable

Points: 5061

June 2, 2008 at 6:20 am

#822859

select @@version

Wilfred van Dijk SSCrazy Eights Points: 9003 More actions · Answer 2

Also, check BOL for the item Serverproperty

Wilfred
The best things in life are the simple things

Deepak-405225 SSCertifiable Points: 6120 More actions · Answer 3

Select serverproperty('productversion') will also provide you the desired result. Refer this link for more info,

http://support.microsoft.com/kb/321185

[font="Verdana"]- Deepak[/font]

Manoj-485464 SSCrazy Points: 2717 More actions · Answer 4

Select @@version will give you the server version. Server propery is the next thing.

Manoj

MCP, MCTS (GDBA/EDA)

Vinit Srivastava SSC-Addicted Points: 431 More actions · Answer 5

Vinit Srivastava

SSC-Addicted

Points: 431

June 3, 2008 at 1:08 am

#823434

Hi friend,

For this use select @@version .

Chandrachurh Ghosh Hall of Fame Points: 3001 More actions · Answer 6

SELECT @@VERSION will give you all the details of the version and the name of the product you are using......to know other you can use Select serverproperty( ).......checkout the property names available from Books On Line......Best of luck.......

Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.

M&M SSC-Insane Points: 21700 More actions · Answer 7

you could also execute below xp

exec xp_msver

M&M

steveb. SSC-Forever Points: 46733 More actions · Answer 8

Or look at the values in the brackets next to the server name in SSMS Object Explorer

Manoj-485464 SSCrazy Points: 2717 More actions · Answer 9

So, Deat friend, All the things to check the MS version. Try one or the other and get the version.

Manoj

MCP, MCTS (GDBA/EDA)

Ayyappan Thangaraj Old Hand Points: 364 More actions · Answer 10

select @@version

will tell you the full software version and its name

anjan.ashok SSCrazy Points: 2783 More actions · Answer 11

USe

SELECT @@VERSION AS 'SQL Server Version'

and

xp_msver

it returns information about the actual build number of the server and information about the server environment.

Thanks

Manoj-485464 SSCrazy Points: 2717 More actions · Answer 12

Why everyone is giving the same answer? If answer is already posted Please DO NOT GIVE THE SAME ANSWERS.

Manoj

MCP, MCTS (GDBA/EDA)

steveb. SSC-Forever Points: 46733 More actions · Answer 13

didn't you give the same answer as Rajan John after him? 🙂

but i do agree..