In 2000 :database go offline,Index tuning wizard In 2005:Database go off/o

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

Question Posted / dinesh

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

Please Help Members By Posting Answers For Below Questions

What are the basic functions for master, msdb, model, tempdb databases?

1049

what does the automatic recovery do? : Sql server administration

1025

How can I know what locks are running on which resource?

958

How data can be copied from one table to another table?

954

What are subqueries in sql server? Explain its properties.

1025

Where do you find the default Index fill factor and how to change it?

1066

Does hive support indexing?

968

How to see existing views in ms sql server?

1049

Explain collation?

1070

What is the use of keyword with encryption. Create a store procedure with encryption?

966

How to test subquery results with the exists operator?

1108

Explain the concepts and capabilities of sql server?

981

Explain what are various ways to enhance the ssrs report?

1046

Why we use functions in sql server?

1085

How to access the deleted record of an event?

1040