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 is ViewState and How it is managed,Its Advantages/Benefits?

4 Answers   Google,


What is the difference between asp.net and mvc?

0 Answers  


What are directives in asp.net?

0 Answers  


How asp.net mvc differs from asp.net web forms? : asp.net mvc

0 Answers  


Explain how server control validation controls works?

2 Answers   CMS, Syntax Softtech,






Which is better union or union all?

0 Answers  


what is CTS?

3 Answers   PrimeLine,


What is view state and how it works in asp net?

0 Answers  


Why do we need a web application session?

0 Answers  


what is generics?

2 Answers   Microsoft,


How Web Service help? What is the difference between Remoting & Web Servcies?

2 Answers  


In your web.config file which attribute of <Globalization> element identifies the default culture that will be used for web request?

1 Answers  


Categories