default databases available in sql server and there uses ?
- 4 Answers
- 7402 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / selvam
There are 5 default DB's in Sql server
1. Master - Contains all of the system level information
2. Model- Used as a template db for all db instances created in SQL Server
3. Msdb -- It used by sql server agent, Mail Service
4. Tempdb -- Contains temporary objects and intermediate results
5. Resource -- it is read only db that contains system objects that are included with sql server
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to enter binary string literals in ms sql server?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Can one drop a column from a table?
What is subquery? Explain the properties of a subquery?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is an indexed view?
How do I start sql server 2017?
What is a view in sql?
What kind of problems occurs if we do not implement proper locking strategy?
What is a scheduled job or what is a scheduled task?
Is it possible to have clustered index on separate drive from original table location?
Disadvantages of the indexes?
How do I create a trace in sql server?
What is sql or structured query language?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
