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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 32 or 64 how can you tell

Author  Topic 

muzzettemm
Posting Yak Master

212 Posts

Posted - 2009-01-06 : 16:00:23
hi all i have a silly question, with sql server 2005 how can you tell if you have the 32bit of the 64bit??

thnk you

muzzettemm
Posting Yak Master

212 Posts

Posted - 2009-01-06 : 16:10:13
I know

SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVER PROPERTY ('edition') 
gives you the version

Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-06 : 16:11:50
Select @@Version

X86 - 32-bit
X64 - 64-bit
Go to Top of Page

muzzettemm
Posting Yak Master

212 Posts

Posted - 2009-01-06 : 16:24:53
thank you
Go to Top of Page
   

- Advertisement -