469,963 Members | 1,943 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,963 developers. It's quick & easy.

Which one better SQL Server 2000 or 2005 for ASP NEt

Hi all..

i'm newbie in aspnet. i kind a confuse which one should i use for my
database system. SQL 2000 or 2005, and what is the different.

thankyou

Jun 12 '07 #1
1 1071
Usually, the newer version of SQL Server the better. Mostly it's features
available. SQL Server 2005 has a lot of things different about it.
Unfortunatley, most won't mean much to you if you haven't developed for SQL
Server for a while. SQL Server 2005 is nice because there is a free express
version that you can download and use to get your feet wet with developing
for SQL server. One of the nice features is the inclusion of a native XML
datatype within SQL Server, as well as integration with the .Net CLR. Like I
said though, a lot of these things won't mean much if you haven't been
developing with them for a while. One of the important factors though, is
determining which version your chosen web host has. If your host/company
only has SQL Server 2000 and isn't planning to upgrade anytime soon, you may
as well start with SQL Server 2000 since it's always easier to upgrade to a
newer version then it is to check if you've used features from a newer
version to go backwards from SQL 2005 to SQL 2000.

--
Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006

<ha**********@gmail.comwrote in message
news:11*********************@o11g2000prd.googlegro ups.com...
Hi all..

i'm newbie in aspnet. i kind a confuse which one should i use for my
database system. SQL 2000 or 2005, and what is the different.

thankyou

Jun 12 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Howard | last post: by
17 posts views Thread by Danieltbt05 | last post: by
14 posts views Thread by Developer | last post: by
2 posts views Thread by Igor | last post: by
1 post views Thread by kb0odu.tj | last post: by
1 post views Thread by rainxy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.