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 mean by a neutral culture?

0 Answers   MindCracker,


Explain http handlers? Where we can use the http handlers?

0 Answers   Accenture,


Explain one critical mapping?

0 Answers  


What are the authentication types in asp.net?

0 Answers  


We are using Jscriopt validations and at clint site javascript is not running that time validation would work? if yes then how it would behave?

0 Answers  






Can One website be made using two different languages like c#,vb.net etc......

4 Answers   ABC,


How can you pass multiple complex types in Web API?

0 Answers  


Where session variables are stored?

0 Answers  


What are session state modes?

0 Answers  


How to do state management in ASP.NET?

0 Answers   BirlaSoft,


Should validation (did the user enter a real date) occur server-side or client-side? Why?

4 Answers   Siebel Systems,


What is the difference between asp.net mvc and asp.net webforms? : asp.net mvc

0 Answers  


Categories