Interested to Buy Any Domain ? << Click Here >> for more details...
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
- 0 Answers
- 1035 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Explain the properties of sub-query in sql server?
Which sql server is best?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
What are the elements of dbms?
How can you start sql server in different modes?
What is the difference between clustered and non-clustered indexes in ms sql server?
Tell me what is a linked server?
What is the function of sql server agent windows service?
Can I delete event logs?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
11 Answers World Tech, Yardi Software,
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is the use of set nocount on/off statement?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
