membership on sql server 2000?

Hello,

I'm programming asp.net 2.0 with a mySql database.
Now I want to implement membership-features.
I consider converting mySql to SQL server 2000 because then I don't have to build a custom membershipprovider.
my question is: does membership work as good on sqlserver2000 as it does on sqlserver2005? (my host doesn't support sqlserver2005 (yet).

another question: can I expect problems converting the database from mysql to sqlserver2000?

leonvr:

my question is: does membership work as good on sqlserver2000 as it does on sqlserver2005? (my host doesn't support sqlserver2005 (yet).

Sure. I also use SQL2000 as backend database for membership. You can take a look at this article:

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

leonvr:

another question: can I expect problems converting the database from mysql to sqlserver2000?

Sorry I have no idea on migrating mysql to sql2000.

sql