SA for database ownership?

• SQLDCH

  SSChampion

  Points: 11601

  More actions

  February 8, 2012 at 9:35 am

  #1444622

  You're exactly right Jeff, I completely mis-spoke. I meant to say that they suggest that blanket ownership by the 'sa' account is not a best practice, which is what we were discussing. The group further pointed out that this should be interpreted per environment.

  Again, thanks for the correction.

  ----------------------------------------------------------------------------
  Sacramento SQL Server users group - http://sac.sqlpass.org
  Follow me on Twitter - @SQLDCH
  ----------------------------------------------------------------------------

  Yeah, well...The Dude abides.

• Jeff Moden

  SSC Guru

  Points: 1003943

  More actions

  February 15, 2012 at 9:37 pm

  #1447642

  SQLDCH (2/8/2012)

  ---

  You're exactly right Jeff, I completely mis-spoke. I meant to say that they suggest that blanket ownership by the 'sa' account is not a best practice, which is what we were discussing. The group further pointed out that this should be interpreted per environment.

  Again, thanks for the correction.

  Nah... no problem. I've done the same thing in the past. Thank you for taking it the right way and for the gentlemanly feedback.

  --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)