When you first load SQL SERVER you will startup with what
all databases?
- 3 Answers
- 5949 Views
- CompuSol, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mobin sathupally
When we install SQL SERVER totally we got six databases.
Among six four are system databases and remaining two are
user defined databases,
The system databases are 1.Master
2.Model
3.Msdb and
4.Tempdb.
The user defined databases are 1.Northwind and
2.Pubs.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / rajesh s. chandan
It depends of Microsoft SQLm Server version.
When we install Microsoft SQL Server 2008 then SQL Server
installer will install following database.
System databases
1.master
2.model
3.msdb
4.tempdb
If we configure replication then it will create
distribution database.
When we install Reporting Services (SSRS) , then it will
install ReportServer and ReportServerTempDB. We could also
install sample databases like AdventureWorks and
AdventureWorksDW.
Whenever, we restart the SQL Server, it will freshly create
tempdb database. Hope this information will help you.
| Is This Answer Correct ? | 0 Yes | 0 No |
What do you understand by check constraint in sql server?
Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?
What does set rowcount do?
Define Check points and End Points?
How do I clean up sql server transaction log?
How you can get a list of all the table constraints in a database?
In which situation you use Self joins?
1 Answers CarrizalSoft Technologies, HP, TCS,
How to sort the query output with order by clauses in ms sql server?
Difference between: - Delete & Truncate - Table & View - Constraints & Triggers
Explain transaction server auto commit?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
