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

Can the query output be sorted by multiple columns in ms sql server?

562


what are the different types of SSRS reports?

112


Is it possible to create trigger on views?

555


What is a trigger what are the advantages of trigger?

535


What are the key configuration files for sql server reporting services ?

120






How to access the inserted record of an event?

584


Explain nested trigger in sql?

601


What are the difference between data mart and data warehouse? : sql server analysis services, ssas

512


What is the difference between for trigger and after trigger?

555


How to receive returning result from a query?

592


How to create a new login name in ms sql server?

557


What is autocommit mode in sql server?

553


What is normalization of database?

611


Define Wed Edition in SQL Azure?

80


How to create a scrollable cursor with the scroll option?

506