-
problem with the selection of service pack.
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|