Thursday, March 22, 2012

32 bit version

How can I find out if the server is 32 bit ?
ThanksHi
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...
> > How can I find out if the server is 32 bit ?
> >
> > Thanks
>
>|||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...
> 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...
>> > How can I find out if the server is 32 bit ?
>> >
>> > Thanks
>>|||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...
> > 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...
> >> > How can I find out if the server is 32 bit ?
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>|||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...
> > 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...
> >> > How can I find out if the server is 32 bit ?
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>|||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...
> 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...
>> > 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...
>> >> > How can I find out if the server is 32 bit ?
>> >> >
>> >> > Thanks
>> >>
>> >>
>> >>
>>|||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...
> > 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...
> >> > 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...
> >> >> > How can I find out if the server is 32 bit ?
> >> >> >
> >> >> > Thanks
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||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...
>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...
>> > 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...
>> >> > 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...
>> >> >> > How can I find out if the server is 32 bit ?
>> >> >> >
>> >> >> > Thanks
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||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...
> >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...
> >> > 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...
> >> >> > 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...
> >> >> >> > How can I find out if the server is 32 bit ?
> >> >> >> >
> >> >> >> > Thanks
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I couldn't go anywhere no matter I clicked on yes or no. I had to use the
task manager to stop the process.
The sp4 couldn't get installed , don't know why. did I do something wrong?
Thanks a lot.
"Catelin Wang" 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...
> > >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...
> > >> > 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...
> > >> >> > 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...
> > >> >> >> > How can I find out if the server is 32 bit ?
> > >> >> >> >
> > >> >> >> > Thanks
> > >> >> >>
> > >> >> >>
> > >> >> >>
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >|||It is working fine now.
"Catelin Wang" wrote:
> I couldn't go anywhere no matter I clicked on yes or no. I had to use the
> task manager to stop the process.
> The sp4 couldn't get installed , don't know why. did I do something wrong?
> Thanks a lot.
> "Catelin Wang" 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...
> > > >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...
> > > >> > 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...
> > > >> >> > 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...
> > > >> >> >> > How can I find out if the server is 32 bit ?
> > > >> >> >> >
> > > >> >> >> > Thanks
> > > >> >> >>
> > > >> >> >>
> > > >> >> >>
> > > >> >>
> > > >> >>
> > > >> >>
> > > >>
> > > >>
> > > >>
> > >
> > >
> > >

No comments:

Post a Comment