Database mirriong database snapshot CLR integration DDL Trigger Schema

what is advantages in sql 2005 over sql 2000?

Question Posted / adhi

4 Answers
7986 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is difference between line feed ( ) and carriage return ( )?

910

What are different types of subquery?

1247

Where are full-text indexes stored?

996

What are three major types of constraints?

1121

Can we install sql server 2016 on windows 7?

1142

What are security principals used in sql server 2005?

989

Which is faster statement or preparedstatement?

952

How do I clean up sql server transaction log?

1071

Explain use of expression builder.

1029

How to find the list of fixed hard drive and free space on server?

1204

What is local temp table?

966

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1111

Define Wed Edition in SQL Azure?

100

What are the different sql server versions?

984

How to assign null values to variables or columns?

979