what is advantages in sql 2005 over sql 2000?

Answer Posted / subbu

Newly introduced in Sql server 2005
======================================
DDL trigger (This trigger fired only create new table or
Drop table or Alter table).Created in either Database or
Server.
To Deploy .Net procedures.
CLR Integration.
TRY & CATCH Mehod (For Error Handling).

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different type of replication in sql server?

529


What is the importance of a recovery model?

600


Explain logical operators in sql server?

564


List out the differences between the clustered index and non-clustered index in sql server?

498


Where the sql logs gets stored?

535






Explain features of analysis services?

514


Do you know the different ddl commands in sql?

585


what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

641


Indexes are updated automatically is the full-text index also updated automatically?

619


How do I schedule a sql server profiler trace?

535


Do you know the cursor types?

614


what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

551


Explain something about security and SQL Azure?

88


What are the fixed server level roles? : sql server security

541


What is the purpose of the tempdb database?

568