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
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What is normalization and denormalization in sql server?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What is log shipping?
Difference between 2NF &3NF ?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Do you know how to store and query spatial data?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
Is it true, that there is no difference between a rule and a check constraint?
What area unit the various kinds of info compression introduced in sql server 2008?
Tell me about normalization in DBMS.
How to include date and time values in sql statements?
How to delete duplicate records based on single column from a table?
What is field in algebra?