can you any body tell me suppose database is suspect mode.
how can take to normal?
Answer Posted / kumar.t
EXEC sp_resetstatus 'database name'
By
Kumar.T
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Describe in brief sql server monitoring ways.
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
Define Joins?
What is data source in connection string?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What are the differences between clustered and non-clustered index?
What is inline table-value user-defined function?
What is the use of @@spid?
Is it possible to call a stored procedure within a stored procedure?
How to provide column names in insert statements in ms sql server?
What is the purpose of update statistics and scope_identity() function?
How do I trace a query in sql server?
In which format does an image save in SQL Server database ?
Why does sql studio use a single registered database repository? : sql server management studio