Hi
I am considering taking the plunge to .Net.

Could anyone offer me the advantages and pluses that I will gain from an Application Development point of view, using SQL Server 2K.

Regards
Ian

What is this topic asking about? SQL server or VB6/VB.net?

With regards to the choice between VB6/VB.net: go with VB.net, hands down. Don't even think about pre-.net VB. It's a horse-and-buggy to BMW upgrade.

Regarding SQL Server 2k, I'm not sure how to answer that. You haven't posed much else that I could use to give you any insight. If you want to develop games, I'd say that SQL server isn't going to help you much. What are you planning on developing? For a simple response I'd say that if you need to build an application with database support, then MS-SQL2K is certainly a way to go. .net has built in classes in the System.Data.SqlClient namespace that provide very good communications directly with SQL-Server with the need for the OLE or ODBC layer. This makes it faster and more efficient.

Peter
------------------------------------------------------
Work smarter, not harder.

Peter thanks for the reply
Ignore the SQL Server bit, my question was solely regarding VB.Net v VB. Sorry for the confusion.

I currently use VB6 for writing window applications with SQL Server as the database.

Hal Levy has posted a good reply

http://p2p.wrox.com/topic.asp?TOPIC_ID=7917

Advantages in VB.NET

* Threading "Robust control over threads"
* Remoting "More reliable than COM / DCOM"
* Easier Deployment "Flexible Deplyment Wizard"
* No Dll registration "Just copy your program to the user"
* Easier Installation "Small size appliation, copy and paste"
* True object oriented (Inheritance, Interfaces ..."


Hope this help.

Ash