what is advantages in sql 2005 over sql 2000?

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

How to replace given values with null using nullif()?

566


What is a covered index?

512


How to get a list of columns in a view using "sys.columns" in ms sql server?

510


Write an sql query for deleting duplicate rows?

543


How to attach adventureworkslt physical files to the server?

620






What is use of except clause? How it differs from not in clause?

591


Define right outer join?

540


How to achieve Paging of records in SQL SERVER?

585


How to create a simple table to test triggers in ms sql server?

501


List some advantages and disadvantages of stored procedure?

554


What is unpivot?

558


Tell me what is difference between view and materialized view?

512


What you can do to delete a table without the delete trigger firing?

512


What happens when unicode strings concatenate with non-unicode strings?

540


Define indexes?

596