473,544 Members | 1,969 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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.


Jun 12 '07 #1
1 1196
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**********@g mail.comwrote in message
news:11******** *************@o 11g2000prd.goog legroups.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.


Jun 12 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: ik | last post by:
ERROR after uninstalling SQL Server 2005 Express I get this message, SQLDMO has not been registered. Please re-run your setupand contact your system administrator. GREAT!!! ReInstalled SQL SERVER 2000 after playing around with SQL Server 2005...
by: Howard | last post by:
Is it compatible with sql server 2000?
by: Danieltbt05 | last post by:
just installed SQL server 2000 and using my client , i can't locate the server. I used SQL query analyzer to search but no servers were found. Error message is as below Server : Msg17,level 16, state1 SQL server does not exist or denied access.
by: thomas_vicker | last post by:
Hi, I need to maintain both SQL Server 2000 and 2005 on my PC for support purposes. I am using the developer additions. After I install everything (with no install errors) I can use SQL 2005 Mgt Studio fine until I bring up SQL 2000 Query Analyzer or Enterprise Mgr. After that, I cannot bring up SQL 2005 Mgt Studio. It get this message: ...
by: alingsjtu | last post by:
Hello, every body. When execute dynamic generated multiple OPENQUERY statements (which linkes to DB2) in SQLServer, I always got SQL1040N The maximum number of applications is already connected to the database. SQLSTATE=57030. Background: I created a linked server to DB2 8.1 database which called GRR_DB2Server. In my stored procedure...
by: Developer | last post by:
Hello All, i have recently installed VS2005 and was trying to install SQL sever 2000. I have Win XP' SP2. But when I tried installing, it only installed client tools and not the database. Can anyone please help me with this as I want to install SQL server and also wouold be grateful, if you can suggest me any workaround to dealwith this...
by: Igor | last post by:
On Win2000 or Win2003 you can use SQL Server 2000 Desktop Edition. On WinXP you must use only SQL Server 2000 Developer Edition. Which SQL Server 2005 I can use on WinXP?
by: JA | last post by:
Is it possible to connect to Sql Server 2005 using an Access 2000 adp? I keep trying, but it doesn't want to accept my id, even though it is right.
by: kb0odu.tj | last post by:
We currently have a database server installed with SQL Server 2005. We're preparing for an application upgrade / conversion that is currently on another database server under SQL Server 2000. Now we are being told by the application vendor that the application will not work with SQL Server 2005. What are the issues with downgrading our SQL...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.