what is the difference between sql 2000 and 2005?

Answers were Sorted based on User's Feedback



what is the difference between sql 2000 and 2005?..

Answer / khv11in

In sql server2000 Extended Stored procedures , and it
modified it into CLR Stored procedures

1.sql server 2005 include interprise manger and query
analyser together in same window we can open many window
tabs in same place but in 2000 it is in different.
2. sql server 2005 support more new datatype like xml
3. we can make more database 2(paw(20))-1 in 2005 in compare
to 2000 where not possible so much database
4. in storeprocedure we can write try catch statemenet in
2005 not in 2000

Is This Answer Correct ?    12 Yes 0 No

what is the difference between sql 2000 and 2005?..

Answer / interviewman

SQL Server has SSIS , SSRS and SSAS

<a href="www.questpond.com">.NET Interview questions</a>

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More ASP.NET Interview Questions

What does the "EnableViewState" property do? Why would I want it on or off?

4 Answers  


1. What is the difference between Cache and Session? 2. I cache limited to page like viewstate or it's accessible through out the application like session? 3. Which one is better when I've some data that is to be used across the application? Why is to better than the other?

2 Answers   247Customer,


What are the types of assemblies and where can u store them and how a private assembly is used only by a single application, and is stored in that application's install directory (or a subdirectory therein)?

3 Answers   Accenture,


What is synchronous and Asynchronous post back ?

0 Answers  


How do you add a javascript function for a link button in a datagrid ?

4 Answers   Microsoft,






Explain the difference between web user control and web custom control?

0 Answers  


What is inheritance and an how it be used, example with an example?

0 Answers   Siebel,


Explain how dot net compiled code will become platform independent?

0 Answers  


Define web.config in .net?

0 Answers  


Explain serialization and deserialization?

0 Answers  


What is cross page posting in asp net?

0 Answers  


How many types of session in ASP.NET

0 Answers   MCN Solutions,


Categories