How to find if you are running 32-bit or 64-bit version in Sql Server

SELECT @@VERSION
--Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)  
--Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Standard Edition (64-bit)
--on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

--windows 32 bit means - X86


SELECT SERVERPROPERTY('Edition')
-- FOR 64 BIT u can see 'Standard Edition (64-bit)'
--for 32 bit you can see 'Standard Edition'

If you have any queries or suggestions, please feel free to ask in comments section.
Share this post :

Post a Comment

Please give your valuable feedback on this post. You can submit any ASP.NET article here. We will post that article in this website by your name.

 
Support : Ranga Rajesh Kumar
Copyright © 2012. ASP.NET Examples - All Rights Reserved
Site Designed by Ranga Rajesh Kumar