Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    Question Unanswered: Dbowner For The Model Database

    How do I change the Database owner for a MODEL database?
    When I open the properties for a Model database, it shows "UNKNOWN" as the database owner, and I can't run the command 'sp_changedbowner 'sa' as it's not allowed to run on master, model, and tempdb.
    Any help?

  2. #2
    Join Date
    Mar 2004
    Location
    London, UK
    Posts
    71
    why would you want to, it's used as the template for future databases created on the server.

  3. #3
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185
    Because I cannot run the sp_helpdb command.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •