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.
--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.
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.