answersLogoWhite

0

Hi Everybody, I am Vijay.According 2 me the differences are: 1. In SQL Server 2000 the Query Analyzer and Enterprise Manager are seperate,whereas in SQL Server 2005 both were combined as Management Studio. 2. In Sql 2005,the new datatype XML is used,whereas in Sql 2000 there is no such datatype 3. In Sql server2000 we can create 65,535 databases,whereas in Sql server2005 2(pow(20))-1 databases can be created.

User Avatar

Wiki User

17y ago

What else can I help you with?

Related Questions

What is the diff between Visual Basic 2005 and Visual Basic dot net?

Visual Basic 2005 is actually a version of VB.NET (v8.0). The latest version (9.0) is Visual Basic 2008.


Why does counter-strike keep taking you to diff servers?

It normally shouldn't.The server you are on may be redirecting you.Or it might seem that you are going to another server while downloading files from a server using sv_downloadurl.


2005 Jeep Liberty diff oil how to change?

2005 jeep liberty 4wd 3.7l how to change diff.oil


2000 GMC Sierra rear diff oil capacity?

about 3 quarts


Diff between 8086 and 8051?

35


How do you identify the rear end of a 2005 ram 1500?

It is a chyrsler 9.25, has a diff cover that looks like a stop sign(octagon) and has 12 diff. cover bolts.


What is the diff between hubs and switches?

Please see:What_is_the_difference_between_a_hub_and_a_switch


Will a front differential from a 2000 s10 fit a 1996 s10?

No it will not, It is all different. Actually yes it will i have to correct you om that i have a 96 blazer same front diff as an s10 and 96 to 03 are the same i just put a 2000 front diff in mine


4x4 s10 front differential interchange between 1996 and 2000?

As long as they are the same gear ratio they interchange also All wheel drive astro vans front diff will work


Difference between net banking and telebanking?

they are not diff they are same


What is the difference between ncc and scout?

diff between official wife and unofficial wife


What is difference between partial differentation and normal diffrentation?

Ordinary Diff -> One variable Partial Diff -> More than one variable


What gear lube do you use on a 2000 chev S-10 front diff?

You can use synthetic 75W-90 if you are using a gasket between the diff cover and the housing. If you are using RTV sealant with no gasket, use the conventional gear oil 80W-90. It seems the synthetic lube dissolves the RTV sealer.


What type of rear diff oil do you need for a 2000 GMC sierra?

0w80 synthetic gear oil.


What is the diff between magic and superstitions?

Magick is a craft. Superstitions are beliefs.


Diff between clocked SR flipflop and SR flipflop?

bokum


What is difference between gaj or yard?

no diff 1 gaj = yard


What time diff between ist?

5 hour 30 min


What is the difference between pricing inventory and valuation inventory?

in fact there is no diff.


What is the difference between SQL Server 32 bit and SQL Server 64 bit application and how do you know whether a computer is 32 bit or 64 bit?

right click computer and go 2 properties ull find there wheather ur pc is 64 or 32 bit. the diff is in color depth 64 is best while 32 is good