Hi,

I have SQL 2000 Client (Enterprise Manager, QA etc) installed on my PC.  I
would like to install SQL 2005 native client (Mgnt Studio etc) on the same PC.

Can they be coexisted and both can be used ?  OR
I have to uninstall 2000 client first.

Regards,
Johnny

Hello,

They can co-exist. Make sure you installl the software in seperate
directory.

Thanks
Hari

Show quoteHide quote

Johnny (Joh***@discussions.microsoft.com) writes:
They can co-exist as Hari said.

I just like to make a clafication: SQL Native Client is a single DLL
which contains an updated ODBC driver and an updated OLE DB provider
for SQL 2005. SQL Native is a redistributable component. SQL Native is
about the first which is installed when you run the SQL Server installation.

You are apparently thinking of the Workstation components, of which some
may use SQL Native Client, but far from all do. Management Studio, for
instance, uses SqlClient, a .Net provider. ("Native" in SQL Native Client
refers to that it is in native code, as opposed to the managed code of
..Net.)

Profiler: SQL:StmtRecompile - EvenSubClass definitions?
SQL Server Management Studio - long names in tabs
Help with SQL 2005 and Sourcesafe 6
Diagram changes
automating SSMS reports