lot of differences: 1. mirroring 2. transactional with updatable subscrip

Difference between sql server 2000 and sql server 2005?

Question Posted / pavan

Answer Posted / pavan

lot of differences:
1. mirroring
2. transactional with updatable subscription
3. resource database
4. serialization

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

State the difference between local and global temporary tables?

1125

What are the different types of triggers in SQL SERVER?

1146

What are the limitations in ssrs on sql server express edition?

189

Explain the purpose of indexes?

985

Explain what are sparse columns?

1002

What is an etl file?

963

What is the native system stored procedure to execute a command against all databases?

1038

How to update muliple row in single query?

1069

Is candidate a key?

960

How to drop an existing user defined function in ms sql server?

1035

What is difference between unique and primary key?

920

What are the limitations/drawbacks or ssrs 2008 r2?

140

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

940

on line cluster can we make if yes tell me the procedure

2028

Explain index in sql server?

1024