How to know whether SQL Server 2005 Tools installed are x64 versio

[Database Administrator]

There is no x64 version of these tools. Even if you install SQL Server
2005\8 x64 version, 32Bit versions of these tools will be installed as this
is the only existing version.

Note:
Also, when you check out the properties of shortcut of SSMS, you'll see that
it's executable file is installed to "C:\ Program Files (x86)..."

--
Ekrem Önsoy



"Ajit" wrote in message
news:AB7EF944-11B4-4CB5-91A1-E92D9CF1170B@microsoft.com...
> Hello all,
>
> We've got a SQL Server 2005 64-bit and these components installed:
>
> 1. SQL Server Command Line Query Tool
> 2. Microsoft SQL Server Management Objects Collection
> 3. Microsoft SQL Server 2005 Backward compatibility
>
> My Question is: How can I know for sure if these components are the x64
> version?
>
> Appreciate your comments.
>
> Thanks
> Ajit

[Database Administrator]

Hello all,

We've got a SQL Server 2005 64-bit and these components installed:

1. SQL Server Command Line Query Tool
2. Microsoft SQL Server Management Objects Collection
3. Microsoft SQL Server 2005 Backward compatibility

My Question is: How can I know for sure if these components are the x64
version?

Appreciate your comments.

Thanks
Ajit

[Database Administrator]

Hi Ekrem,

thanks for commenting,

I'm pretty sure there are 2 versions (x86 & x64) of the tools as you can see
from this site:

http://www.microsoft.com/downloads/d...DisplayLang=en

have a look at "Microsoft SQL Server 2005 Command Line Query Utility", you
will find these msi for download:

X86 Package (SQLServer2005_SQLCMD.msi) - 2528 KB
X64 Package (SQLServer2005_SQLCMD_x64.msi) - 4264 KB
IA64 Package (SQLServer2005_SQLCMD_ia64.msi) - 5410 KB

I've re-installed SQLServer2005_SQLCMD & SQLServer2005_XMO using the x64
version msi. However in Add&Remove Programs it doesn't show '64-bit' at the
end of the tiltle as compared to SQL Server title, i see "SQL Server 2005
(64bit)".

Hence after the tools re-installation, I still can't say whether its the x86
version or x64 version..



"Ekrem Önsoy" wrote:

> There is no x64 version of these tools. Even if you install SQL Server
> 2005\8 x64 version, 32Bit versions of these tools will be installed as this
> is the only existing version.
>
> Note:
> Also, when you check out the properties of shortcut of SSMS, you'll see that
> it's executable file is installed to "C:\ Program Files (x86)..."
>
> --
> Ekrem Önsoy
>
>
>
> "Ajit" wrote in message
> news:AB7EF944-11B4-4CB5-91A1-E92D9CF1170B@microsoft.com...
> > Hello all,
> >
> > We've got a SQL Server 2005 64-bit and these components installed:
> >
> > 1. SQL Server Command Line Query Tool
> > 2. Microsoft SQL Server Management Objects Collection
> > 3. Microsoft SQL Server 2005 Backward compatibility
> >
> > My Question is: How can I know for sure if these components are the x64
> > version?
> >
> > Appreciate your comments.
> >
> > Thanks
> > Ajit
>

[Database Administrator]

My mistake, I'm confused with SSMS, as there's no x64 version of this tool.

You'll find tools of x64 version in "C:\Program Files" and you'll find 32Bit
versions of these tools in "C:\Program Files (x64)".

For example, if SQL Server 2005\8 x64 bit version is installed, you'll find
SQLCMD.exe in the "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\"
folder. Also, when you go to properties of this file, you'll see NT AMD64 in
the "Version" tab.

--
Ekrem Önsoy



"Ajit" wrote in message
news:F05B4EBD-6A0F-49A2-89A5-4996F80E7ED4@microsoft.com...
> Hi Ekrem,
>
> thanks for commenting,
>
> I'm pretty sure there are 2 versions (x86 & x64) of the tools as you can
> see
> from this site:
>
> http://www.microsoft.com/downloads/d...DisplayLang=en
>
> have a look at "Microsoft SQL Server 2005 Command Line Query Utility", you
> will find these msi for download:
>
> X86 Package (SQLServer2005_SQLCMD.msi) - 2528 KB
> X64 Package (SQLServer2005_SQLCMD_x64.msi) - 4264 KB
> IA64 Package (SQLServer2005_SQLCMD_ia64.msi) - 5410 KB
>
> I've re-installed SQLServer2005_SQLCMD & SQLServer2005_XMO using the x64
> version msi. However in Add&Remove Programs it doesn't show '64-bit' at
> the
> end of the tiltle as compared to SQL Server title, i see "SQL Server 2005
> (64bit)".
>
> Hence after the tools re-installation, I still can't say whether its the
> x86
> version or x64 version..
>
>
>
> "Ekrem Önsoy" wrote:
>
>> There is no x64 version of these tools. Even if you install SQL Server
>> 2005\8 x64 version, 32Bit versions of these tools will be installed as
>> this
>> is the only existing version.
>>
>> Note:
>> Also, when you check out the properties of shortcut of SSMS, you'll see
>> that
>> it's executable file is installed to "C:\ Program Files (x86)..."
>>
>> --
>> Ekrem Önsoy
>>
>>
>>
>> "Ajit" wrote in message
>> news:AB7EF944-11B4-4CB5-91A1-E92D9CF1170B@microsoft.com...
>> > Hello all,
>> >
>> > We've got a SQL Server 2005 64-bit and these components installed:
>> >
>> > 1. SQL Server Command Line Query Tool
>> > 2. Microsoft SQL Server Management Objects Collection
>> > 3. Microsoft SQL Server 2005 Backward compatibility
>> >
>> > My Question is: How can I know for sure if these components are the x64
>> > version?
>> >
>> > Appreciate your comments.
>> >
>> > Thanks
>> > Ajit
>>

[Database Administrator]

indeed, i could figure out the SQLCMD easily (i did SQLCMD /? at cmdline, it
shows: Version 9.00.3239.00 NT AMD64),

but what I still can't find out is the version for the other 2 components:

> >> > 2. Microsoft SQL Server Management Objects Collection
> >> > 3. Microsoft SQL Server 2005 Backward compatibility

What are the files behind the tolls above, and where are they? I don't see
any obvious dll(s) relating to those 2 other components in my C:\Program
Files\Microsoft SQL Server\90\Tools\binn, except for the SQLCMD.EXE.

I'm especially interested in knowing the version (x86 or x64) of Microsoft
SQL Server 2005 Backward compatibility, because this is causing me some setup
problems of a 3rd party software.


"Ekrem Önsoy" wrote:

> My mistake, I'm confused with SSMS, as there's no x64 version of this tool.
>
> You'll find tools of x64 version in "C:\Program Files" and you'll find 32Bit
> versions of these tools in "C:\Program Files (x64)".
>
> For example, if SQL Server 2005\8 x64 bit version is installed, you'll find
> SQLCMD.exe in the "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\"
> folder. Also, when you go to properties of this file, you'll see NT AMD64 in
> the "Version" tab.
>
> --
> Ekrem Önsoy
>
>
>
> "Ajit" wrote in message
> news:F05B4EBD-6A0F-49A2-89A5-4996F80E7ED4@microsoft.com...
> > Hi Ekrem,
> >
> > thanks for commenting,
> >
> > I'm pretty sure there are 2 versions (x86 & x64) of the tools as you can
> > see
> > from this site:
> >
> > http://www.microsoft.com/downloads/d...DisplayLang=en
> >
> > have a look at "Microsoft SQL Server 2005 Command Line Query Utility", you
> > will find these msi for download:
> >
> > X86 Package (SQLServer2005_SQLCMD.msi) - 2528 KB
> > X64 Package (SQLServer2005_SQLCMD_x64.msi) - 4264 KB
> > IA64 Package (SQLServer2005_SQLCMD_ia64.msi) - 5410 KB
> >
> > I've re-installed SQLServer2005_SQLCMD & SQLServer2005_XMO using the x64
> > version msi. However in Add&Remove Programs it doesn't show '64-bit' at
> > the
> > end of the tiltle as compared to SQL Server title, i see "SQL Server 2005
> > (64bit)".
> >
> > Hence after the tools re-installation, I still can't say whether its the
> > x86
> > version or x64 version..
> >
> >
> >
> > "Ekrem Önsoy" wrote:
> >
> >> There is no x64 version of these tools. Even if you install SQL Server
> >> 2005\8 x64 version, 32Bit versions of these tools will be installed as
> >> this
> >> is the only existing version.
> >>
> >> Note:
> >> Also, when you check out the properties of shortcut of SSMS, you'll see
> >> that
> >> it's executable file is installed to "C:\ Program Files (x86)..."
> >>
> >> --
> >> Ekrem Önsoy
> >>
> >>
> >>
> >> "Ajit" wrote in message
> >> news:AB7EF944-11B4-4CB5-91A1-E92D9CF1170B@microsoft.com...
> >> > Hello all,
> >> >
> >> > We've got a SQL Server 2005 64-bit and these components installed:
> >> >
> >> > 1. SQL Server Command Line Query Tool
> >> > 2. Microsoft SQL Server Management Objects Collection
> >> > 3. Microsoft SQL Server 2005 Backward compatibility
> >> >
> >> > My Question is: How can I know for sure if these components are the x64
> >> > version?
> >> >
> >> > Appreciate your comments.
> >> >
> >> > Thanks
> >> > Ajit
> >>
>

[Database Administrator]

Then you should take a look at the setup logs. You can find these logs:
"c:\program files\microsoft sql server\90\setup bootstrap\log\files"

You'll see "sqlsetup000x__backwardscompat_x.log" which has a
lot of info about the installation of this component, including the CPU
architecture info.

--
Ekrem Önsoy



"Ajit" wrote in message
news:5B539442-9016-4446-AC8F-DA6A2C38431B@microsoft.com...
> indeed, i could figure out the SQLCMD easily (i did SQLCMD /? at cmdline,
> it
> shows: Version 9.00.3239.00 NT AMD64),
>
> but what I still can't find out is the version for the other 2 components:
>
>> >> > 2. Microsoft SQL Server Management Objects Collection
>> >> > 3. Microsoft SQL Server 2005 Backward compatibility
>
> What are the files behind the tolls above, and where are they? I don't see
> any obvious dll(s) relating to those 2 other components in my C:\Program
> Files\Microsoft SQL Server\90\Tools\binn, except for the SQLCMD.EXE.
>
> I'm especially interested in knowing the version (x86 or x64) of Microsoft
> SQL Server 2005 Backward compatibility, because this is causing me some
> setup
> problems of a 3rd party software.
>
>
> "Ekrem Önsoy" wrote:
>
>> My mistake, I'm confused with SSMS, as there's no x64 version of this
>> tool.
>>
>> You'll find tools of x64 version in "C:\Program Files" and you'll find
>> 32Bit
>> versions of these tools in "C:\Program Files (x64)".
>>
>> For example, if SQL Server 2005\8 x64 bit version is installed, you'll
>> find
>> SQLCMD.exe in the "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\"
>> folder. Also, when you go to properties of this file, you'll see NT AMD64
>> in
>> the "Version" tab.
>>
>> --
>> Ekrem Önsoy
>>
>>
>>
>> "Ajit" wrote in message
>> news:F05B4EBD-6A0F-49A2-89A5-4996F80E7ED4@microsoft.com...
>> > Hi Ekrem,
>> >
>> > thanks for commenting,
>> >
>> > I'm pretty sure there are 2 versions (x86 & x64) of the tools as you
>> > can
>> > see
>> > from this site:
>> >
>> > http://www.microsoft.com/downloads/d...DisplayLang=en
>> >
>> > have a look at "Microsoft SQL Server 2005 Command Line Query Utility",
>> > you
>> > will find these msi for download:
>> >
>> > X86 Package (SQLServer2005_SQLCMD.msi) - 2528 KB
>> > X64 Package (SQLServer2005_SQLCMD_x64.msi) - 4264 KB
>> > IA64 Package (SQLServer2005_SQLCMD_ia64.msi) - 5410 KB
>> >
>> > I've re-installed SQLServer2005_SQLCMD & SQLServer2005_XMO using the
>> > x64
>> > version msi. However in Add&Remove Programs it doesn't show '64-bit' at
>> > the
>> > end of the tiltle as compared to SQL Server title, i see "SQL Server
>> > 2005
>> > (64bit)".
>> >
>> > Hence after the tools re-installation, I still can't say whether its
>> > the
>> > x86
>> > version or x64 version..
>> >
>> >
>> >
>> > "Ekrem Önsoy" wrote:
>> >
>> >> There is no x64 version of these tools. Even if you install SQL Server
>> >> 2005\8 x64 version, 32Bit versions of these tools will be installed as
>> >> this
>> >> is the only existing version.
>> >>
>> >> Note:
>> >> Also, when you check out the properties of shortcut of SSMS, you'll
>> >> see
>> >> that
>> >> it's executable file is installed to "C:\ Program Files (x86)..."
>> >>
>> >> --
>> >> Ekrem Önsoy
>> >>
>> >>
>> >>
>> >> "Ajit" wrote in message
>> >> news:AB7EF944-11B4-4CB5-91A1-E92D9CF1170B@microsoft.com...
>> >> > Hello all,
>> >> >
>> >> > We've got a SQL Server 2005 64-bit and these components installed:
>> >> >
>> >> > 1. SQL Server Command Line Query Tool
>> >> > 2. Microsoft SQL Server Management Objects Collection
>> >> > 3. Microsoft SQL Server 2005 Backward compatibility
>> >> >
>> >> > My Question is: How can I know for sure if these components are the
>> >> > x64
>> >> > version?
>> >> >
>> >> > Appreciate your comments.
>> >> >
>> >> > Thanks
>> >> > Ajit
>> >>
>>

[Database Administrator]

Thanks Ekrem, the logs did show me some important info (as in which msi setup
was used to install the tool).

Thanks for the help mate!

"Ekrem Önsoy" wrote:

> Then you should take a look at the setup logs. You can find these logs:
> "c:\program files\microsoft sql server\90\setup bootstrap\log\files"
>
> You'll see "sqlsetup000x__backwardscompat_x.log" which has a
> lot of info about the installation of this component, including the CPU
> architecture info.
>
> --
> Ekrem Önsoy
>
>
>
> "Ajit" wrote in message
> news:5B539442-9016-4446-AC8F-DA6A2C38431B@microsoft.com...
> > indeed, i could figure out the SQLCMD easily (i did SQLCMD /? at cmdline,
> > it
> > shows: Version 9.00.3239.00 NT AMD64),
> >
> > but what I still can't find out is the version for the other 2 components:
> >
> >> >> > 2. Microsoft SQL Server Management Objects Collection
> >> >> > 3. Microsoft SQL Server 2005 Backward compatibility
> >
> > What are the files behind the tolls above, and where are they? I don't see
> > any obvious dll(s) relating to those 2 other components in my C:\Program
> > Files\Microsoft SQL Server\90\Tools\binn, except for the SQLCMD.EXE.
> >
> > I'm especially interested in knowing the version (x86 or x64) of Microsoft
> > SQL Server 2005 Backward compatibility, because this is causing me some
> > setup
> > problems of a 3rd party software.
> >
> >
> > "Ekrem Önsoy" wrote:
> >
> >> My mistake, I'm confused with SSMS, as there's no x64 version of this
> >> tool.
> >>
> >> You'll find tools of x64 version in "C:\Program Files" and you'll find
> >> 32Bit
> >> versions of these tools in "C:\Program Files (x64)".
> >>
> >> For example, if SQL Server 2005\8 x64 bit version is installed, you'll
> >> find
> >> SQLCMD.exe in the "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\"
> >> folder. Also, when you go to properties of this file, you'll see NT AMD64
> >> in
> >> the "Version" tab.
> >>
> >> --
> >> Ekrem Önsoy
> >>
> >>
> >>
> >> "Ajit" wrote in message
> >> news:F05B4EBD-6A0F-49A2-89A5-4996F80E7ED4@microsoft.com...
> >> > Hi Ekrem,
> >> >
> >> > thanks for commenting,
> >> >
> >> > I'm pretty sure there are 2 versions (x86 & x64) of the tools as you
> >> > can
> >> > see
> >> > from this site:
> >> >
> >> > http://www.microsoft.com/downloads/d...DisplayLang=en
> >> >
> >> > have a look at "Microsoft SQL Server 2005 Command Line Query Utility",
> >> > you
> >> > will find these msi for download:
> >> >
> >> > X86 Package (SQLServer2005_SQLCMD.msi) - 2528 KB
> >> > X64 Package (SQLServer2005_SQLCMD_x64.msi) - 4264 KB
> >> > IA64 Package (SQLServer2005_SQLCMD_ia64.msi) - 5410 KB
> >> >
> >> > I've re-installed SQLServer2005_SQLCMD & SQLServer2005_XMO using the
> >> > x64
> >> > version msi. However in Add&Remove Programs it doesn't show '64-bit' at
> >> > the
> >> > end of the tiltle as compared to SQL Server title, i see "SQL Server
> >> > 2005
> >> > (64bit)".
> >> >
> >> > Hence after the tools re-installation, I still can't say whether its
> >> > the
> >> > x86
> >> > version or x64 version..
> >> >
> >> >
> >> >
> >> > "Ekrem Önsoy" wrote:
> >> >
> >> >> There is no x64 version of these tools. Even if you install SQL Server
> >> >> 2005\8 x64 version, 32Bit versions of these tools will be installed as
> >> >> this
> >> >> is the only existing version.
> >> >>
> >> >> Note:
> >> >> Also, when you check out the properties of shortcut of SSMS, you'll
> >> >> see
> >> >> that
> >> >> it's executable file is installed to "C:\ Program Files (x86)..."
> >> >>
> >> >> --
> >> >> Ekrem Önsoy
> >> >>
> >> >>
> >> >>
> >> >> "Ajit" wrote in message
> >> >> news:AB7EF944-11B4-4CB5-91A1-E92D9CF1170B@microsoft.com...
> >> >> > Hello all,
> >> >> >
> >> >> > We've got a SQL Server 2005 64-bit and these components installed:
> >> >> >
> >> >> > 1. SQL Server Command Line Query Tool
> >> >> > 2. Microsoft SQL Server Management Objects Collection
> >> >> > 3. Microsoft SQL Server 2005 Backward compatibility
> >> >> >
> >> >> > My Question is: How can I know for sure if these components are the
> >> >> > x64
> >> >> > version?
> >> >> >
> >> >> > Appreciate your comments.
> >> >> >
> >> >> > Thanks
> >> >> > Ajit
> >> >>
> >>
>