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

What are the new data types are introduced in sql 2000?

864

What is an indexed view?

922

Explain how to use linked server?

935

Can we call stored procedure in trigger?

911

What is RAID? What are the different types of RAID configurations?

1067

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

181

What are “unrepeatable reads”?

1184

When you use @@error and try-catch?

991

Explain the purpose of indexes?

910

What is the difference between char, varchar and nvarchar?

984

Explain what is analysis service repository?

934

Can we insert data into a view?

1069

What is difference between clustered index and non clustered index?

1037

Write a query to find 5th highest amount paid from the customer table.

891

Please differentiate between a local and a global temporary table?

956