Compatibility between sql express and MSDE

I need to know if I will run into problems with sql express on a sql 2000 server. I get the impression that my isp is using 200 server just by lookng at the connection string. Is there a addin I could use if needed I seen a post mentioning the publishing wizard cpt but not much after is it released yet. and then there is the web data admnistrator for msde will that work with sql express.One other question can I reinstall sql and change the authentication process from windows to user name and password.

DKB

Compatibility between sql express and MSDE there is none, it is not simple to move SQL Server 2005 database to 2000 it is covered in details by another user in the thread below.

http://forums.asp.net/thread/1494648.aspx

To use SQL Server with password you need to change to mixed authentication mode and that is covered in the SQL Server docs below. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms188670.aspx

|||

Thank you Caddre I guess I will have to wait and see by the looks of it I have two options find a new isp or unistall the instances that are installed and remove sql express and install msde.

DKB