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

#21

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:

Quote:

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_<instance_name>_backwardscompat_x.lo g" which has a
lot of info about the installation of this component, including the CPU
architecture info.

--
Ekrem Önsoy

"Ajit" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:5B539442-9016-4446-AC8F-DA6A2C38431B (AT) microsoft (DOT) 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" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:F05B4EBD-6A0F-49A2-89A5-4996F80E7ED4 (AT) microsoft (DOT) 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" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:AB7EF944-11B4-4CB5-91A1-E92D9CF1170B (AT) microsoft (DOT) 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

#22

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:

Quote:

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_<instance_name>_backwardscompat_x.lo g" which has a
lot of info about the installation of this component, including the CPU
architecture info.

--
Ekrem Önsoy

"Ajit" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:5B539442-9016-4446-AC8F-DA6A2C38431B (AT) microsoft (DOT) 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" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:F05B4EBD-6A0F-49A2-89A5-4996F80E7ED4 (AT) microsoft (DOT) 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" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:AB7EF944-11B4-4CB5-91A1-E92D9CF1170B (AT) microsoft (DOT) 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

#23

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:

Quote:

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_<instance_name>_backwardscompat_x.lo g" which has a
lot of info about the installation of this component, including the CPU
architecture info.

--
Ekrem Önsoy

"Ajit" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:5B539442-9016-4446-AC8F-DA6A2C38431B (AT) microsoft (DOT) 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" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:F05B4EBD-6A0F-49A2-89A5-4996F80E7ED4 (AT) microsoft (DOT) 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" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:AB7EF944-11B4-4CB5-91A1-E92D9CF1170B (AT) microsoft (DOT) 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

#24

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:

Quote:

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_<instance_name>_backwardscompat_x.lo g" which has a
lot of info about the installation of this component, including the CPU
architecture info.

--
Ekrem Önsoy

"Ajit" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:5B539442-9016-4446-AC8F-DA6A2C38431B (AT) microsoft (DOT) 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" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:F05B4EBD-6A0F-49A2-89A5-4996F80E7ED4 (AT) microsoft (DOT) 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" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:AB7EF944-11B4-4CB5-91A1-E92D9CF1170B (AT) microsoft (DOT) 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

#25

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:

Quote:

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_<instance_name>_backwardscompat_x.lo g" which has a
lot of info about the installation of this component, including the CPU
architecture info.

--
Ekrem Önsoy

"Ajit" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:5B539442-9016-4446-AC8F-DA6A2C38431B (AT) microsoft (DOT) 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" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:F05B4EBD-6A0F-49A2-89A5-4996F80E7ED4 (AT) microsoft (DOT) 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" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:AB7EF944-11B4-4CB5-91A1-E92D9CF1170B (AT) microsoft (DOT) 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

#26

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:

Quote:

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_<instance_name>_backwardscompat_x.lo g" which has a
lot of info about the installation of this component, including the CPU
architecture info.

--
Ekrem Önsoy

"Ajit" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:5B539442-9016-4446-AC8F-DA6A2C38431B (AT) microsoft (DOT) 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" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:F05B4EBD-6A0F-49A2-89A5-4996F80E7ED4 (AT) microsoft (DOT) 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" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:AB7EF944-11B4-4CB5-91A1-E92D9CF1170B (AT) microsoft (DOT) 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

#27

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:

Quote:

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_<instance_name>_backwardscompat_x.lo g" which has a
lot of info about the installation of this component, including the CPU
architecture info.

--
Ekrem Önsoy

"Ajit" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:5B539442-9016-4446-AC8F-DA6A2C38431B (AT) microsoft (DOT) 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" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:F05B4EBD-6A0F-49A2-89A5-4996F80E7ED4 (AT) microsoft (DOT) 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" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:AB7EF944-11B4-4CB5-91A1-E92D9CF1170B (AT) microsoft (DOT) 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

#28

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:

Quote:

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_<instance_name>_backwardscompat_x.lo g" which has a
lot of info about the installation of this component, including the CPU
architecture info.

--
Ekrem Önsoy

"Ajit" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:5B539442-9016-4446-AC8F-DA6A2C38431B (AT) microsoft (DOT) 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" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:F05B4EBD-6A0F-49A2-89A5-4996F80E7ED4 (AT) microsoft (DOT) 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" <Ajit (AT) discussions (DOT) microsoft.com> wrote in message
news:AB7EF944-11B4-4CB5-91A1-E92D9CF1170B (AT) microsoft (DOT) 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Re: How to know whether SQL Server 2005 Tools installed are x64 ve - 11-11-2008 , 07:19 AM

Re: How to know whether SQL Server 2005 Tools installed are x64 ve - 11-11-2008 , 07:19 AM

Re: How to know whether SQL Server 2005 Tools installed are x64 ve - 11-11-2008 , 07:19 AM

Re: How to know whether SQL Server 2005 Tools installed are x64 ve - 11-11-2008 , 07:19 AM

Re: How to know whether SQL Server 2005 Tools installed are x64 ve - 11-11-2008 , 07:19 AM

Re: How to know whether SQL Server 2005 Tools installed are x64 ve - 11-11-2008 , 07:19 AM

Re: How to know whether SQL Server 2005 Tools installed are x64 ve - 11-11-2008 , 07:19 AM

Re: How to know whether SQL Server 2005 Tools installed are x64 ve - 11-11-2008 , 07:19 AM