dbo

• pfernandez-851320

  SSC Veteran

  Points: 222

  More actions

  August 15, 2008 at 1:33 pm

  #189487

  Hello,

  I am new to SQL server and keep seeing dbo everywhere in the books I read.

  What is the significance of this, what does it mean and must I use it

  Thanks

  Phil

• Jeff Moden

  SSC Guru

  Points: 1004436

  More actions

  August 17, 2008 at 6:39 pm

  #859213

  It means "DataBase Owner" and is a server role. Lookup server roles in Books Online.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• karthik M

  One Orange Chip

  Points: 29139

  More actions

  August 18, 2008 at 5:00 am

  #859355

  Some useful links to you.

  http://msdn.microsoft.com/en-us/library/aa905208(SQL.80).aspx

  http://www.sqldba.org/articles/17-SQL-DBO-SQL-Server-Database-Object-Owner-dbo.aspx

  Please read more on this URL.

  karthik