How to tell what version of SQL Server

Question

Viewing 4 posts - 1 through 4 (of 4 total)

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

lucky-80472 SSCertifiable Points: 7793 More actions · Answer 1

Hello David,

Go through one of the earlier thread.

Thanks and have a nice day!!!

Lucky

David Garrett SSC Journeyman Points: 86 More actions · Answer 2

Thank you for your post. Your post and KB info says to execute:

SELECT 'productversion = ', SERVERPROPERTY('productversion')

SELECT 'productlevel = ', SERVERPROPERTY('productlevel')

SELECT 'edition = ', SERVERPROPERTY('edition')

Which returns:

productversion = 8.00.760

productlevel = SP3

edition = Enterprise Edition

What I need to know is whether the software is for 32-bit or 64-bit.

shama Tirmal Reddy Newbie Points: 8 More actions · Answer 3

run select @@version

in the output you can observe X86 --means 32-bit

if the out is IA64 -means 64- bitcheers