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 is table join?

1071

What is inner join? Explain with an example?

1126

What is difference between stored procedure and user defined function?

1045

What do you mean by the term 'normalization'?

1137

What happens if null values are involved in string operations?

934

Explain what stored procedure sp_replcounters is used for? : sql server replication

1463

Explain table valued parameters in sql server? Why tvp used?

975

How many types of triggers in sql server?

979

Explain primary key?

908

How to connect sql server management studio express to sql server 2005 express?

977

What command would you use to create an index?

991

What are distinctive joins find as a part of sql?

918

Can we perform backup restore operation on tempdb?

965

How to connect to SQL Azure Database by using sqlcmd?

136

How would you go about developing a ssrs report?

162