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
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
Is the order of columns in the set clause important in ms sql server?
What is the order in which the sql query is executed?
What are the characteristics of modern DBMS?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What is a partition function in sql server?
How retrieve field names from the table in SQL through JAVA code?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What are different types of raid levels?
Give a example to search fr a string in all stored procedure in sql server.
What is resultset concur_updatable?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What are indexes in ms sql server?
How to create stored procedures with parameters in ms sql server?
What are various aggregate functions that are available?