Download SQL Server client tools

Hi.
Despite the indignance of some people, here is the link to download the SQL
Server Client Tools for use with MSDE.
http://download.microsoft.com/downl...SP4-x86-ENU.EXE
I have downloaded MSDE and the Client Tools myself so I know this to be the
case. I came across this page when searching for the client tools for a new
laptop on which I have already installed MSDE.
I do wish that people would not confuse "I don't know how to do something" w
ith "it cannot be done." There's very little in this universe that cannot b
e done
Anyway, in answer to your question, you were half right. The download is on
ly part of SP4 (thankfully) and therefore only weighs about 67MB, and not th
e 240MB total SP size.
I hope this helps. Have fun!
Captain Murphy
All hail the Barbot-Bot!!!
Courtesy of EggHeadCafe.com
Earn money answering messageboard posts at
http://www.eggheadcafe.com/forummerit.aspxI believe most people are looking for ways which are in
compliance with licensing agreements. You need a valid,
legal SQL Server CAL to install the client tools. If someone
does not have this, the methods you are suggesting are not
legal.
The gist of it is explained in the following link:

>Incidentally, if you can't install from the SP4 download, download the SQL
Server 2000 Evaluation and simply install just the Client Tools.
>[url]http://www.microsoft.com/downloads/thankyou.aspx?familyId=D20BA6E1-F44C-4781-A6BB
-F60E02DC1335&displayLang=en" target="_blank">http://sqlserver2000.databases.aspf...&displayLang=en
>It's a bigger download, but has the desired effect.
>Enjoy!
>Captain Murphy
>All hail the Barbot-Bot!!!
>Courtesy of EggHeadCafe.com
>Earn money answering messageboard posts at
>http://www.eggheadcafe.com/forummerit.aspx

Download SQL Server client tools

Hi.
Despite the indignance of some people, here is the link to download the SQL Server Client Tools for use with MSDE.
http://download.microsoft.com/downlo...P4-x86-ENU.EXE
I have downloaded MSDE and the Client Tools myself so I know this to be the case. I came across this page when searching for the client tools for a new laptop on which I have already installed MSDE.
I do wish that people would not confuse "I don't know how to do something" with "it cannot be done." There's very little in this universe that cannot be done
Anyway, in answer to your question, you were half right. The download is only part of SP4 (thankfully) and therefore only weighs about 67MB, and not the 240MB total SP size.
I hope this helps. Have fun!
Captain Murphy
All hail the Barbot-Bot!!!
Courtesy of EggHeadCafe.com
Earn money answering messageboard posts at
http://www.eggheadcafe.com/forummerit.aspx
I believe most people are looking for ways which are in
compliance with licensing agreements. You need a valid,
legal SQL Server CAL to install the client tools. If someone
does not have this, the methods you are suggesting are not
legal.
The gist of it is explained in the following link:
http://sqlserver2000.databases.aspfa...rver/msde.html
The appropriate uses of MSDE is no longer posted on
Microsoft's site since the release of 2005, but the related
Q and A stated:
Q. Can I use SQL Server tools and services in conjunction
with MSDE?
A. You can only use SQL Server tools and services in
conjunction with MSDE if you acquired MSDE through SQL
Server 2000 (Developer Edition, Standard Edition, or
Enterprise Edition), and if you are using MSDE in
conjunction with a properly licensed copy of SQL Server
2000. Visit the How to Buy page for information on obtaining
a valid SQL Server license.
Note: The tools and services included with SQL Server
Developer Edition may not be used to manage production
server environments.
-Sue
On Mon, 02 Oct 2006 13:30:12 -0700, Captain Murphy wrote:

>Incidentally, if you can't install from the SP4 download, download the SQL Server 2000 Evaluation and simply install just the Client Tools.
>http://www.microsoft.com/downloads/t...displayLang=en
>It's a bigger download, but has the desired effect.
>Enjoy!
>Captain Murphy
>All hail the Barbot-Bot!!!
>Courtesy of EggHeadCafe.com
>Earn money answering messageboard posts at
>http://www.eggheadcafe.com/forummerit.aspx

don't allow duplicates problem

I have MSDE with the server tools from sql server 2000 enterprise edition. I
am having a problem with one of my tables. The table is set up with two
fields Class and Student. I want there to be only one student of the same
name in each class. If i use the primary key it will just allow only one
student of the same name in the entire table and wouldn't look at the class
that the student is taking. Is there an easy way around this?
I found a solution, I created a dual primary key. I highlighted both items
and then turned on the primary key and it does exactly what I wanted it to
except the maximum size is 900bytes for a primary key so I had to adjust the
length of the fields a bit.
"Benjamin" wrote:

> I have MSDE with the server tools from sql server 2000 enterprise edition. I
> am having a problem with one of my tables. The table is set up with two
> fields Class and Student. I want there to be only one student of the same
> name in each class. If i use the primary key it will just allow only one
> student of the same name in the entire table and wouldn't look at the class
> that the student is taking. Is there an easy way around this?

Does the Sql Server 2005 EVAL distribution support run of packages under DtExec?

I believe I have made a complete install of Sql Server 2005 on my dev. machine, including all client tools, and can run SSIS packages from the dev. environment.

However DtExec refuses to run any package and always throws the "insufficient version" error (as does the "RunPackage" component, probably for the same reason).

I have repeatedly attempted to find something more to install from the Sql Server 2005 eval release that will allow DTExec to run without the "insufficient version" error, but can find nothing else to install from the eval. The install wizard (and the "change" wizard) indicates everything is installed and will not build a list of any additional components to install.

Are we sure that DtExec will install and run from a sql server 2005 eval distribution?

Licenses are in the pipeline (not that pipleine) but we need to start testing our SSIS solution in the meantime.

p.s. Kudos to the dev. team, it really is an excellent tool!

Thanks,

Ken

This sounds like the SSIS services feature is missing, you may just have the workstation components. If running on a workstation OS, then this can be an issue-

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112469&SiteID=1

|||

Thanks for the reply Darren.

The O.S. is Windows 2000 Advanced Server, and to the best of my ability I have confirmed and reconfirmed that every possible installable component and piece of software provided in the Sql Server 2005 eval. distro. has been fully installed in the runtime environment in question.

I recently used the same Sql Server 2005 distro. to perform an identical install onto an XP Pro machine and DtExec seems to run fine.

So I will assume I have some kind of flawed installation on the win2k advanced server box and will try a complete deinstall and reinstall as my last resort.