Database mirriong database snapshot CLR integration DDL Trigger Schema

what is advantages in sql 2005 over sql 2000?

Question Posted / adhi

Answer Posted / adhi

Database mirriong
database snapshot
CLR integration
DDL Trigger
Schema
we can install up to up 50 instance (in 2000 only 16)
Try& CATCH

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How many databases instances are there in sql server 2000?

581

Can truncate be rolled back?

545

Can you explain important index characteristics?

527

What is bcp? When does it used?

551

How is table type constraint applied to a table?

551

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

631

What is importing utility?

553

How do I partition a table in sql server?

541

what is a check constraint?

643

1 01 101 01010

1572

what stored procedure would you use to view lock information? : Sql server administration

585

How to delete an existing database user?

537

How you can minimize the deadlock situation?

556

What different steps will a sql server developer take to secure sql server?

506

How to delete all rows with truncate table statement in ms sql server?

494