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
 Transact-SQL (2005)
 32 or 64 bit

Author  Topic 

vasu4us
Posting Yak Master

102 Posts

Posted - 2009-03-02 : 09:59:46
Hi all,
How do we know if a server is running a 32 bit sql server or a 64 bit.
how can we conform?

thanks,
Sri

Skorch
Constraint Violating Yak Guru

300 Posts

Posted - 2009-03-02 : 11:09:03
SELECT @@VERSION will do it (X86 or X64)

Some days you're the dog, and some days you're the fire hydrant.
Go to Top of Page

vasu4us
Posting Yak Master

102 Posts

Posted - 2009-03-02 : 11:47:56
Thanks, I been working on this for good enough time but i never new it.
Go to Top of Page

Skorch
Constraint Violating Yak Guru

300 Posts

Posted - 2009-03-02 : 12:31:31
You're welcome :)

Some days you're the dog, and some days you're the fire hydrant.
Go to Top of Page
   

- Advertisement -