Printable View
Dear friends,
I have a problem with the selection of download file in the microsoft website for SP4.
For 32 bit database pattern and for 64 bit database pattern they are providing 2 separate files. I want to select the right one which fit to my current environment.
So how i know the bit pattern of my current database
and how i know the bit pattern in operating system level.
Any reply to my doubts is greatly appreciating.
I am new in your group. please help me.
Thank you
Ichayan
What version of SQL Server are you using?. You can get that by running
select @@version
Download the SP4 for the version that you have.
Hi skhanal,
my version is sp3a.
i have to upgrade to sp4 with build 2187.
If you go to the following link you can see that there are two separate files for 32 bit and 64 bit database. here which one i have to choose. how i know my database is 32 bit level or 64 bit level.
please ...help me.
Thank you
If you see (Intel X86) in result of 'select @@version', you have 32-bit sql2k. By the way, 64-bit sql2k works on Itanium machine only.
HI friends,
THANK YOU FOR YOUR HELPS.
I REALY PROUD BY JOINING WITH YOU IN THE DISCUSSIONS.
THANKS A LOT
ICHAYAN
Just curious if 'select @@version' statement actually shows us the SQL server version; because last time when I ran this command it showed me the windows version.
Thanks
In fact, it gives you both sql and os version.
Oops I didn't pay attention to it. Thanks for the info.