Changing dbo login to sa

• Grinja

  Hall of Fame

  Points: 3590

  More actions

  August 6, 2008 at 9:10 am

  #71796

  Hi all,

  I have a situation where the Login 'DBO' links to an domain user who no longer exists.

  I would like to change this to the 'sa' login and from there make dbo the owner of the database using

  EXEC sp_changedbowner 'dbo'

  Apparently this works in to 2005:

  ALTER AUTHORIZATION ON DATABASE:: dbName TO sa

  Is there an equivelant in SQL 2000?

  Any help is appreciated!

• Grinja

  Hall of Fame

  Points: 3590

  More actions

  August 6, 2008 at 10:42 am

  #853993

  Okay problem solved ...

  came across this on someones blog which is the equivelant to the ALTER Authorisation in SQL 2005

  SQL 2000::hehe:

  EXEC dbName..sp_changedbowner 'sa';