Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic functions for master, msdb, tempdb databases?
- 2 Answers
- 17086 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / pinak
the basics function of master is "it stores all sytem level
information in it, all databases which need for user
defineed database.
msdb is microsoft database.it works just like a recorder.
tempdb is a temprary database.
| Is This Answer Correct ? | 8 Yes | 10 No |
Post New Answer View All Answers
What are the reporting services components?
How do you Implement SSIS Packages in your Project?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
Explain sql server service broker?
Explain different types of collation sensitivity?
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 transact-sql ddl trigger?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
How to create a view using data from another view?
Is truncate a dml command?
Define msdb database?
What do we have to check in database testing?
Can you please explain the difference between primary keys and foreign keys?
What is the difference between createstatement and preparedstatement?
