wat is the main diff between sql server 2000and sql server 2005

Answer Posted / dinesh

In 2000 :database go offline,Index tuning wizard
In 2005:Database go off/online,Database tunning advisor
In 2008 :Same as 2005

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define ACID properties in a Database?

634


In which sql server version report builder introduced?

105


What is coalesce in sql server?

541


How to create a ddl trigger using "create trigger" statements?

621


How to optimize stored procedures in sql server?

634






Explain candidate key, alternate key, and composite key?

594


What are the dmvs? : sql server database administration

602


What is the use of custom fields in report?

561


where the connection string store in the database

1532


What is pessimistic concurrency?

546


What is the difference between ‘having’ clause and a ‘where’ clause?

557


How to receive returning result from a query?

588


What is save transaction and save point?

630


What do you mean by normalisation?

508


Can we deploy SSRS reports on our personal website?

123