Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


wht's the differece between sqlserver05 and sqlserver2000

Answers were Sorted based on User's Feedback



wht's the differece between sqlserver05 and sqlserver2000..

Answer / jerry joseph

.NET Runtime integration
SQL Server 2005 is integrated with .NET Runtime

Email sending capability
You can send emails from SQL Server 2005 which you couldnt
do with SQL Servr 2000

TRY CATCH error handling
In SQL Server 2005 we have TRY CATCH for better error
handling. We had only @@ERROR in SQL Server 2000 which was
very primitive

Is This Answer Correct ?    2 Yes 0 No

wht's the differece between sqlserver05 and sqlserver2000..

Answer / monal

SQL 2005: Database Snapshot, SNAPSHOT Isolation
Level, .NET, CLR, Online Backup, Online Index Building

Is This Answer Correct ?    0 Yes 0 No

wht's the differece between sqlserver05 and sqlserver2000..

Answer / velmurugan,uk

There are many differences interms of
1.Architecture,
2.Services,
3.Performance,
4.Scalability,
5.Design and Deployment application,
6.Tools
and so on...

Is This Answer Correct ?    0 Yes 1 No

Post New Answer



More SQL Server Interview Questions

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,


What is page in sql server?

0 Answers  


What are the pros and cons of creating extended stored procedures?

1 Answers  


What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  


What are the advantages of passing name-value pairs as parameters?

0 Answers  






What is create statement?

0 Answers  


What does it mean to normalize data?

0 Answers  


what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  


What is ms sql server triggers?

0 Answers  


How do I setup a local sql server database?

0 Answers  


Explain nested trigger in sql?

0 Answers  


How to assign null values to variables or columns?

0 Answers  






Categories