sql server editions relared question

[rizunb]

Hi people

Ok I understand that sqlserver 2000 standard and enterprize
editions can on work on windows 2000 advance server or higher and sqlserver 2000 personal and developer edition can work on windows 2000 professional.

Now what i dont know is which edition i need to use.
what I want to do is :

1) connect SQL Server to VB.NET applications through ODBC
2) Write some sql inside VB to manipulate records like insert, delete and update records in sqlserver
3) be able to create and delete tables in sqlserver
4) write few stored procedures and calling them within VB.NET
5) connect ASP.NET with sqlserver through IIS

Now to be able to do all these, do I need sqlserver 2000 standard edition or developer edition will do all these?????

Thanks in advance

 

[fluteplr]

Developer will do it, BUT it is licensed for development/testing only. You cannot run a production server with the developer version. I suggest reading the eula for more detailed information.

 

[SQLBill]

This link might help:

http://www.microsoft.com/sql/techinfo/planning/SQLResKChooseEd.asp

It's Microsoft's white paper on Choosing an Edition of SQL Server.

-SQLBill

 

[RiverGuy]

Also, for #1, why would you want to use ODBC when .Net has SqlConnections built into the framework?

There are also other, cheaper options. If you AREN'T running a production database, and $400 for developer is still alot, and you don't need much space, you could get some SQL space from a web host for $10-$20 a month use that.