SQL Server Performance

How to remove login from user

Discussion in 'General DBA Questions' started by aaronsandy, Mar 4, 2005.

  1. aaronsandy New Member

    Hi!
    I want to remove the "sa" login for the user dbo.How to do this.
    every time I create a db the login "sa" automatically assigs to the user dbo for the new db.pls suggest
  2. Luis Martin Moderator

    Dbo.Sa is administrative user. You can't delete it.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  3. derrickleggett New Member

    Instead, set the password to something incredibly long and complicated that you could never have a possibility of remotely remembering. Then, change it every 30 days. Here is a good example of an sa password.

    ASJLaljffdj:ldfu)#&)&)&uquew)euR03Q2PU03UQOAFUOPF#%)u0[329

    Yep, that would about do it.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.

Share This Page