32 bit version

How can I find out if the server is 32 bit ?
Thanks
Hi
select @.@.version will have a value of "Intel X86"
Have a look at xp_msver too:
EXEC xp_msver Platform
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Catelin Wang" <CatelinWang@.discussions.microsoft.com> wrote in message
news:AFDE713D-0957-4F3D-AA7E-0A56E368E741@.microsoft.com...
> How can I find out if the server is 32 bit ?
> Thanks
|||Thanks Mike, I tested both of your suggestions, it is "x86" , which means 32
bit vesion.
I am going to install sp4 and the hotfix (AWE enabled and more than half
memory is being used by sql server), do I have to be the local admin to do
these?
Thanks.
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> select @.@.version will have a value of "Intel X86"
> Have a look at xp_msver too:
> EXEC xp_msver Platform
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Catelin Wang" <CatelinWang@.discussions.microsoft.com> wrote in message
> news:AFDE713D-0957-4F3D-AA7E-0A56E368E741@.microsoft.com...
>
>
|||Hi
Yes and Yes.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Catelin Wang" <CatelinWang@.discussions.microsoft.com> wrote in message
news:37E4A1BB-4DA3-450B-ADFF-382B0B3C96FA@.microsoft.com...[vbcol=seagreen]
> Thanks Mike, I tested both of your suggestions, it is "x86" , which means
> 32
> bit vesion.
> I am going to install sp4 and the hotfix (AWE enabled and more than half
> memory is being used by sql server), do I have to be the local admin to do
> these?
> Thanks.
> "Mike Epprecht (SQL MVP)" wrote:
|||Thanks and I will do the upgrade in a minute.
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Yes and Yes.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Catelin Wang" <CatelinWang@.discussions.microsoft.com> wrote in message
> news:37E4A1BB-4DA3-450B-ADFF-382B0B3C96FA@.microsoft.com...
>
>
|||One more question, Do have have to put the sp4 to a specific location ? or
any where I wish in the computer?
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Yes and Yes.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Catelin Wang" <CatelinWang@.discussions.microsoft.com> wrote in message
> news:37E4A1BB-4DA3-450B-ADFF-382B0B3C96FA@.microsoft.com...
>
>
|||Hi
The Extraction of SP$ does not matter where you put it, as long as you don't
put it into the SQL Server install directory. After you have extracted it,
run setup.bat to install the SP.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Catelin Wang" <CatelinWang@.discussions.microsoft.com> wrote in message
news:FB18CCF5-B3A5-48F9-8F15-FC1C1D136C9B@.microsoft.com...[vbcol=seagreen]
> One more question, Do have have to put the sp4 to a specific location ?
> or
> any where I wish in the computer?
> "Mike Epprecht (SQL MVP)" wrote:
|||I have downloaded the sp4 already. it is a .exe file, when I click to
install, it has a default "c:\sql2ksp4" can I just leave it there?
Thanks for your help.
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> The Extraction of SP$ does not matter where you put it, as long as you don't
> put it into the SQL Server install directory. After you have extracted it,
> run setup.bat to install the SP.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Catelin Wang" <CatelinWang@.discussions.microsoft.com> wrote in message
> news:FB18CCF5-B3A5-48F9-8F15-FC1C1D136C9B@.microsoft.com...
>
>
|||No. You have only extracted it. Now you have to go and run
c:\sql2ksp4\setup.bat and actually install it.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Catelin Wang" <CatelinWang@.discussions.microsoft.com> wrote in message
news:B09BE6BF-5AC6-4F64-8549-98396B881581@.microsoft.com...[vbcol=seagreen]
>I have downloaded the sp4 already. it is a .exe file, when I click to
> install, it has a default "c:\sql2ksp4" can I just leave it there?
> Thanks for your help.
> "Mike Epprecht (SQL MVP)" wrote:
|||NOw I got a error message:
The driver sofoware you are installing has not been properly signed with
authendicode(AM)Tachnology . There fore windowns can't tell if the software
has been modified since it was published. The publisher's identity can't be
verified because of a problem:
The prometer is incorrect .
Do you still want to install this software?
Thanks
"Mike Epprecht (SQL MVP)" wrote:

> No. You have only extracted it. Now you have to go and run
> c:\sql2ksp4\setup.bat and actually install it.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Catelin Wang" <CatelinWang@.discussions.microsoft.com> wrote in message
> news:B09BE6BF-5AC6-4F64-8549-98396B881581@.microsoft.com...
>
>
sql