Whenever
a new database is created, the server wants to keep track of who created that
database. This is known as the database owner. By
default, Microsoft SQL Server creates a special account named dbo(for
database owner). When
you create a database but do not specify the owner, this account is used. The dbo
account is also given rights to all types of operations that can be performed
on the database. When
you install Microsoft SQL Server, it also installs 4 databases named master,
model, msdb,
and tempdb. You should avoid directly
using them, unless you know exactly what you
are doing.
Subscribe to:
Post Comments (Atom)
GEN AI
Stay Tuned....
-
Common BI queries Relational queries Vs OLAP queries Before moving to terms used in Data warehouse, let us see the architect...
-
From yesterday onwards, I am stuck up with an error while trying to deploy cube. " You cannot deploy the model because the localhost ...
-
CRM Involves managing all aspects of a customer’s relationship with an organization to increase customer loyalty and retention and an organ...
No comments:
Post a Comment