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

How would ASP and ASP.NET applications run at the same time on the same server?

0 Answers   Satyam,


Explain the boxing and unboxing concept in .net?

0 Answers  


What are validator? Name the Validation controls in asp.net? How do u disable them?

2 Answers  


What is http session state?

0 Answers  


what is webpart? what r the parts in this webpart (zone)

2 Answers  






Is it possible to prevent a browser from caching an ASPX page?

3 Answers  


WHAT IS polymorphism

2 Answers   Fidelity,


How ASP.NET page works?

0 Answers   MCN Solutions,


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

3 Answers  


I am having four text boxes in my web application. I am setting Required Field validator to each Text box. And I am having two buttons in my application. If i clicked the first button only first two text box validation will get fire. Dont show error message for remaining two text box. If i clicked second button last two text box validation will get fired. It will not consider the first two validation controls. That is how to enable and disable the validation controls.

4 Answers  


Explain how dot net compiled code will become platform independent?

0 Answers  


Explain the differences between Server-side and Client-side code?

3 Answers  


Categories