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

Describe in brief sql server monitoring ways.

1035

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1122

Define Joins?

1010

What is data source in connection string?

888

What specific conditions database should meet, before you can bulk copy data into it using bcp?

963

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

887

What are the differences between clustered and non-clustered index?

1003

What is inline table-value user-defined function?

1090

What is the use of @@spid?

983

Is it possible to call a stored procedure within a stored procedure?

950

How to provide column names in insert statements in ms sql server?

1129

What is the purpose of update statistics and scope_identity() function?

1080

How do I trace a query in sql server?

932

In which format does an image save in SQL Server database ?

980

Why does sql studio use a single registered database repository? : sql server management studio

981