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 do you test your database? : sql server database administration

950

What is snapshot parameter in ssrs?

140

Do you know nested transaction?

905

When we should use @@error?

908

How to transfer an existing table from one schema to another schema in ms sql server?

925

What is the difference between Clustered and Non-Clustered Index?

1010

What are scalar functions?

946

Explain what are partitioned views and distributed partitioned views?

889

What are the difference between primary keys and foreign keys?

913

Explain user defined functions?

946

Can we hide the definition of a stored procedure from a use?

1133

How to apply cascading referential integrity in place of triggers?

967

How network traffic be reduced by using the stored procedure?

1044

What is a result set object returned by odbc_exec()?

950

Why use stored procedures in sql server?

952