Can I install sql 2005 march ctp in a machine with sql 2000?

What will happen to my databases?

Will I be able to uninstall sql 2005 without problems?

[90 byte] By [LuisValencia] at [2008-2-5]
# 1
I suggest installing it as a new instance, it will run sidebyside in this case. Then you can detach and copy databases over as you need them.

-Euan

EuanGarden at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...
# 2

If I have 2 different instances one for sql 2000 and one for sql 2005. Can I have my databases on both instances?

I ask this. because maybe we can migrate databases because we may use the new feature of making stored procedures assemblys. But the database should still work on sql 2000 while we studio sql 2005.

LuisValencia at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...
# 3

Once a database has been touched by a 2005 server it can not be used on a 200 server, so I think the answer to your question is no.

-Euan

EuanGarden at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...

SQL Server

Site Classified