CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. June 27th, 2006, 07:01 AM #1
    hthm
    hthm is offline Member
    Join Date
    Dec 2004
    Posts
    49

    changing Dadabase Owner in Sql2000

    hi there ..

    in Sql 2000
    how to change the owner of the DB after it is created


    thanks..
    Reply With Quote Reply With Quote
  2. June 27th, 2006, 07:07 AM #2
    Shuja Ali's Avatar
    Shuja Ali
    Shuja Ali is offline Elite Member Power Poster
    Join Date
    Jun 2004
    Location
    Kashmir, India
    Posts
    6,808

    Re: changing Dadabase Owner in Sql2000

    You can use sp_changedbowner stored procedure to change the owner of the database.
    Code:
    EXEC sp_changedbowner 'NEWUSER'
    Remember the account under which this command will be executed should be member of the sysadmin group.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured