Buying and Installing SQL 2005

Greetings...

I don't know if you have this question being asked before, but I searched and I didn't find. I'm not an expert in SQL issues.

I'm used to doing some programming on ASP on my personal computer. I use the SQL 2000 as a database - I used to use to SQL 2000 enterprise manager to manage my database on my local computer or to enter my database on the web hosting companies. Any way, my question is: I have now windows vista. I'd like to install SQL 2005 to do my usual work.

What version of sql 2005 should have for this personal use as mentioned above?

I totally appreciate any help or additional information regarding this topic since i'm not an expert and still new in this field

Thanks

It depends on how you are going to be using SQL Server, if you are running a production site, using it as a learning tool, number of connections, db sizes, etc. Check out the feature comparison chart listed here:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspxhttp://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

and also the detailed explanation of the different editions here:

http://www.microsoft.com/sql/editions/default.mspx

If you have any further questions, let us know.

Thanks,
Sam Lester (MSFT)

|||For learning purposes, I recommend using Deveoper Edition. It has all the same features as Enterprise -and it will install on a client OS. (I think that it is only about $50.)