What is the basic functions for master, msdb, tempdb databases?
- 2 Answers
- 15452 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 is wrong with sql server client libarary dll, ntwdblib.dll?
What do I need to start working with sql studio? : sql server management studio
Can you create a logon trigger in sql server 2005 express edition?
What is data compression? : sql server database administration
What is Replication?
Which is the main third-party tool used in sql server?
Explain error and transaction handling in sql server?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
How to bind a view to the schema of the underlying tables?
What do you mean by the term 'normalization'?
You want to implement the one-to-many relationship while designing tables. How would you do it?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
How to configure and test odbc dsn settings?
What is side by side migration in sql server?
How to check table values in sql server?
