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

What is index in an assignment?

954

What is the syntax to execute the sys.dm_db_missing_index_details?

1028

What is report server project?

147

what is the system function to get the current user's user id? : Sql server database administration

1022

What do you understand by a stored procedure?

1088

Can a table be moved to different filegroup?

976

Explain about service Broker functions?

1032

Explain linked server in sql?

1220

What is lookup override?

1040

Define full outer join?

955

Explain datetimeoffset data type in sal server 2008?

908

Explain the difference between function and stored procedure?

942

What do you understand by user-defined function in the sql server?

952

What are the ways available in sql server to execute sql statements?

1135

How to create an identity column?

1222