wht's the differece between sqlserver05 and sqlserver2000

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How you would rewrite the sql query to return the customerid sorted numerically?

575


Is sql different from sql server?

516


What is database dimension? : sql server analysis services, ssas

625


How to drop an existing stored procedure in ms sql server?

548


How to optimize stored procedures in sql server?

632






In what sequence sql statement is processed?

585


How to sort query output in descending order in ms sql server?

549


What stored procedure would you use to view lock information?

529


How do you run a trace?

522


what are the critical issues you have resloved in your company

1552


how you can deploy an ssrs report?

127


Can you explain the disadvantages/limitation of the cursor?

507


How to choose all records from the table?

657


How will you make an attribute not process? : sql server analysis services, ssas

586


Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

641