What is the basic functions for master, msdb, tempdb databases?
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
How to download microsoft sql server 2005 express edition?
How to write a query with a left outer join in ms sql server?
What is coalesce in sql server?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is the full form of ddl?
What does indexation mean?
How to create new databases with "create database" statements?
Which is the latest version of sql server and when it is released?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
what protocol both networks use? : Sql server database administration
What is the architecture of ms sql reporting service?
What are the new data types are introduced in sql 2000?
What is the main purpose of having conversation group?
What is function of CUBE ?
Write a query to find 5th highest amount paid from the customer table.