64bit SQl

Hello,
how do I find out if my SQL iNstallation is a 64bit or 32bit installation.
The OS is windows server 2003 64bit.
--
taniHi
Open Error Log and at the top should be written Microsoft SQL Server 2005 -
9.00.3042.00 (X64) which means 64 bit
"tani" <tani@.discussions.microsoft.com> wrote in message
news:508C63C4-BE8A-487C-B130-FA9008A51F15@.microsoft.com...
> Hello,
> how do I find out if my SQL iNstallation is a 64bit or 32bit installation.
> The OS is windows server 2003 64bit.
> --
> tani|||sorry.. but where do I find the error log?
thanks
--
tani
"Uri Dimant" wrote:
> Hi
> Open Error Log and at the top should be written Microsoft SQL Server 2005 -
> 9.00.3042.00 (X64) which means 64 bit
> "tani" <tani@.discussions.microsoft.com> wrote in message
> news:508C63C4-BE8A-487C-B130-FA9008A51F15@.microsoft.com...
> > Hello,
> >
> > how do I find out if my SQL iNstallation is a 64bit or 32bit installation.
> > The OS is windows server 2003 64bit.
> > --
> > tani
>
>|||tani
Do you know the path of SQL Server installation?
By default, the error log is located at Program Files\Microsoft SQL
Server\MSSQL.n\MSSQL\LOG\ERRORLOG
"tani" <tani@.discussions.microsoft.com> wrote in message
news:E4D8091E-2BE7-4DBF-BC4F-E4FA72A32698@.microsoft.com...
> sorry.. but where do I find the error log?
> thanks
> --
> tani
>
> "Uri Dimant" wrote:
>> Hi
>> Open Error Log and at the top should be written Microsoft SQL Server
>> 2005 -
>> 9.00.3042.00 (X64) which means 64 bit
>> "tani" <tani@.discussions.microsoft.com> wrote in message
>> news:508C63C4-BE8A-487C-B130-FA9008A51F15@.microsoft.com...
>> > Hello,
>> >
>> > how do I find out if my SQL iNstallation is a 64bit or 32bit
>> > installation.
>> > The OS is windows server 2003 64bit.
>> > --
>> > tani
>>|||Sorry.. I was looking on the completely wrong place..
I found it now.. thanks a lot!
--
tani
"Uri Dimant" wrote:
> tani
> Do you know the path of SQL Server installation?
> By default, the error log is located at Program Files\Microsoft SQL
> Server\MSSQL.n\MSSQL\LOG\ERRORLOG
>
>
> "tani" <tani@.discussions.microsoft.com> wrote in message
> news:E4D8091E-2BE7-4DBF-BC4F-E4FA72A32698@.microsoft.com...
> > sorry.. but where do I find the error log?
> > thanks
> > --
> > tani
> >
> >
> > "Uri Dimant" wrote:
> >
> >> Hi
> >> Open Error Log and at the top should be written Microsoft SQL Server
> >> 2005 -
> >> 9.00.3042.00 (X64) which means 64 bit
> >>
> >> "tani" <tani@.discussions.microsoft.com> wrote in message
> >> news:508C63C4-BE8A-487C-B130-FA9008A51F15@.microsoft.com...
> >> > Hello,
> >> >
> >> > how do I find out if my SQL iNstallation is a 64bit or 32bit
> >> > installation.
> >> > The OS is windows server 2003 64bit.
> >> > --
> >> > tani
> >>
> >>
> >>
>
>|||TO add to Uri's response, you can get the same info using SELECT @.@.VERSION.
On my 64-but test machine, this returns:
Microsoft SQL Server 2005 - 9.00.3054.00 (X64)
--
Hope this helps.
Dan Guzman
SQL Server MVP
"tani" <tani@.discussions.microsoft.com> wrote in message
news:508C63C4-BE8A-487C-B130-FA9008A51F15@.microsoft.com...
> Hello,
> how do I find out if my SQL iNstallation is a 64bit or 32bit installation.
> The OS is windows server 2003 64bit.
> --
> tani|||Dan
I did not think about it, thanks :-)))
Uh, its time to go home..
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:A1EA8611-5672-4555-8C8F-AA6DCB6EB3C6@.microsoft.com...
> TO add to Uri's response, you can get the same info using SELECT
> @.@.VERSION. On my 64-but test machine, this returns:
> Microsoft SQL Server 2005 - 9.00.3054.00 (X64)
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "tani" <tani@.discussions.microsoft.com> wrote in message
> news:508C63C4-BE8A-487C-B130-FA9008A51F15@.microsoft.com...
>> Hello,
>> how do I find out if my SQL iNstallation is a 64bit or 32bit
>> installation.
>> The OS is windows server 2003 64bit.
>> --
>> tani
>