default databases available in sql server and there uses ?
Answer Posted / rajesh bhawsar
1.Model
Model database is templete. when u create new database
system gives u a copy of model database
2.Tempdb
Tempdb is scratchpad of sql server
3.msdb
4.master
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to connect sql server management studio express to sql server 2005 express?
What is database replication? What are the different types of replication you can set up in sql server?
Which are ddl commands?
What are the new features of sql server 2008 r2 reporting service?
What is the native system stored procedure to execute a command against all databases?
What are sparse columns?
Which sql server is best?
What are the different types of columns types constraints in the sql server?
How to recover from sql injection? : sql server security
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
Explain different backup plans?
What are the properties and different types of sub-queries?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
Do you know sql server 2008 introduces automatic auditing?
Explain left outer join and right outer join?