EXEC sp_resetstatus 'database name' By Kumar.T

can you any body tell me suppose database is suspect mode.
how can take to normal?

Question Posted / kumar.t

Answer Posted / kumar.t

EXEC sp_resetstatus 'database name'

By
Kumar.T

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Why main is user defined function?

1052

How would you use user_constraints table in DB?

1066

What are the differences between sql server and mysql.

1147

Can you edit the .rdl code associated with a linked report?

168

Explain try...catch with sql server?

1072

Explain what are sparse columns?

1071

Can you get second highest salary from the table?

1010

How can you find out how many rows returned in a cursor?

1090

What is a subquery in a select query statement in ms sql server?

1191

How to create a view with data from multiple tables?

1065

What is difference between inner join and full join?

1115

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

1059

What is a non equi join?

1026

Can you please explain the difference between function and stored procedure?

1049

What are the differences between lost updates and uncommitted dependencies?

1147