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
What are the disadvantages of merge replication?
How many types of triggers in sql server?
Which are the new data types introduced in sql server 2008?
Differentiate between truncate vs delete in mssql?
What is a with(nolock)?
What is a raid and what are different types of raid configurations?
What is a transact-sql statement batch in ms sql server?
How to create a new table in a given schema?
What are triggers? How do you invoke a trigger on demand?
How to create an index on an existing table in ms sql server?
SQL Server Architecture ?
How do I create a trace in sql server?
Explain system rowset functions?
What is a schema in ms sql server 2005?
What is the log shipping?