Question on Connectivity tools for SQL 2000 and SQL 2005



  • 1. Backup SQL 2005 to SQL 2000
    Hi, Is there anyway to restore a database that was created on SQL 2005 into SQL 2000. We have a database that I have been doing some testing on, on SQL 2005 and need to restore it back to SQL 2000 but keep getting various messages. I have read that there is no way to do this but thought I would drop a message in here first to confirm this or to find a way to do it? Thanks Mike
  • 2. Backup SQL 2005 - Restore In SQL 2000
    Hi, I have been testing a database in SQL 2005 (keeping it in 2000 Mode from the properties) and need to restore it back to another machine running SQL 2000 SP4. I am getting errors and cannot find a way to do it? Can any one help please? Thanks Mike
  • 3. converting varchar to smallmoney
    Hi My ticket engine stores values in varchar. The sql db-field that corresponds was created as smallmoney. The below statement works for conversion of "leavedays" if the given value is entered without any decimal places (E.G. 4) As soon as a user enters a value that includes decimal places (E.G. 4.5) the conversion will not work. In this case the value 4.5 is rounded to 5. What do i have to do to convert the value as it is entered by the user? Thanks in advance t. Statement: INSERT INTO leavereq (mitarbeiter, startdate, enddate, leavedays, remainingdays, approvedby, approvedon) SELECT {0} , convert(datetime, {1}) , convert(datetime, {2}), convert(numeric, {3}), convert(numeric, {4}),{5}, getdate() DDL for concerned database: CREATE TABLE [dbo].[leavereq] ( [mitarbeiter] char(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [startdate] datetime NULL, [enddate] datetime NULL, [leavedays] smallmoney NULL, [remainingdays] smallmoney NULL, [approvedon] datetime NULL, [approvedby] char(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GO
  • 4. Remember password checkbox does NOT remember password
    SQL Server 2005->SQL Server Management Studio->Connect to Server-window: Remember password-checkbox does not stay checked and the password field is emptied. How many years still for a company that has 31 billion dollars in cash to fix this annoying problem in a login screen on one of their most important products SQL Server 2005? Remember password-checkbox does not remember password.
  • 5. Using COLLATE in ORDER BY?
    Apparently my complaints about sorting can be addressed using the COLLATE clause. So I modified my select like this... select col1, col2 COLLATE Latin1_General_CS_AS_KS_WS from stuff order by col1, col2 COLLATE Latin1_General_CS_AS_KS_WS It appears to have no effect, however. I would have thought that selecting "width sensitive" would answer my problems, but no such luck. Am I doing anything obviously wrong here? Maury

Question on Connectivity tools for SQL 2000 and SQL 2005

Postby shub » Tue, 21 Nov 2006 22:52:33 GMT

Question on just connectivity tools for SQL 2000 and SQL 2005
We are in the process of doing a inplace-upgrade of our SQL Server 2000
to SQL Server 2005. Currently all of the client computers have only the
connectivity tools from SQL 2000 installed in them.  Is it necessary to
upgrade  all the client machines with new SQL 2005 connectivity tools?

Any advice in this regard will be greatly appreciated.

Question on Client tools for SQL 2000 and SQL 2005
The other question I have is I have  a unique client that has SQL 2000
Client tools installed, I am planning to also install the SQL 2005
Client tools, in this scenario when the Client connects to the Server
which client setting does it take. So for instance if in the SQL
Serever 2000 Network Client utility if I have only tcp_ip enabled as
the network protocol and on SQL 2005 if I have only Namedpipes enabled,
how does SQL Server figure out which setting should it look at? Do I
need to keep them consistent for both?


RE: Question on Connectivity tools for SQL 2000 and SQL 2005

Postby Sm9obiBCZWxs » Wed, 22 Nov 2006 03:50:01 GMT


Without upgrading the clients you will not have access to the facilities 
available to the Native Client although this may not be a problem immediately 
after upgrading. 

Depending on what you require the client tools for, then you may not need to 
upgrade them, but you will not have any of the SQL 2005 specific features 
available. The protocol used by your application will depend on what you have 
specified in the connection string, installing SQL 2005 may give you more 
updated versions of the component you use.

If you are not using SQL 2000, I would look at removing the SQL 2000 tools.



Similar Threads:

1.SQL Server 2000/2005 Client Tools and Connectivity

What is the recommended approach regarding the client tools and
application connectivity in a mixed environment where we have SQL
Server 2000 and are starting to migrate to SQL Server 2005.  We will
have a parallel environment of 2000 and 2005 and we have .NET
developers that will need to access and test both versions with their
applications.  What is the preferred or recommended way to handle
this?  Any issues, gotchas, etc?

2.SQL Server 2005 DTS Migration Tool (SQL Server 2000 to SQL Server 2005)

I was wondering what is the best practices for migrating existing DTS packages
over to Beta 2 of SQL Server 2005.
I am going to do "sandbox install" of SQL Server 2005 on Virtual PC 2004
and since I will have a clean install Im after ideas?

Thanks in advance

3.Unix connectivity tools to sql sever 2000

Does anyone know of any shareware tools out there that can connect to
sql server 2000 from Unix(specifically Sun Solaris) and perform
queries and return result sets ? Appreciate your help.

Steve Chiang

4.SQL Mobile 2005 Connectivity Tools - where are they???

Where are these located. I am trying to upgrade my CE 2.0 replication 
share to version 3 but cannot find the connectivity tools. I am running 
SQL server 2000 and do not have a copy of SQLServer 2005 running. The 
microsoft web site says they will be available soon to download however 
I need them now.

Any ideas on what cd they are available on.

regards Paul

5.automated uninstall of sql server 2000 client tools and installation of 2005 tools

Any advice or reference links on mass client upgrade solutions?

On Aug 16, 8:44m,  XXXX@XXXXX.COM  wrote:
> Is there no one else out there having to go through the process of
> updating all of their 2000 clients to 2005 clients?
> thanks,
> M
> On Jul 30, 3:47m, XXXX@XXXXX.COM  wrote:
> > Good afternoon,
> > I was wondering if anyone already had a script to uninstall Sql server
> > 2000 Client tools and then install 2005 client tools and service packs
> > via an automated script and/or SMS package? Thanks in advance
> >Mike- Hide quoted text -
> - Show quoted text -



Who is online

Users browsing this forum: No registered users and 56 guest