Re: change user's login for dbo user
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/20/03
- Previous message: molly: "change user's login for dbo user"
- In reply to: molly: "change user's login for dbo user"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 20 Nov 2003 15:23:34 -0700
You'd want to change the database owner using
sp_changedbowner. You can find more info on the stored
procedure in books online.
-Sue
On Thu, 20 Nov 2003 12:40:21 -0800, "molly"
<anonymous@discussions.microsoft.com> wrote:
>Two of our SQL 2000 databases list the user dbo in the
>Users container and have associated a Windows
>authenticated account (\\domain\user) as the login for
>dbo instead of a SQL server login. We have since renamed
>this Windows account resulting in the dbo user having no
>valid login. I am looking at the books online for
>sp_change_users_login which I thought would fix issue,
>but it indicates this sp cannot be used for dbo user. How
>can I change the login for dbo without breaking the
>database? Help!
>thanks for your help!
- Previous message: molly: "change user's login for dbo user"
- In reply to: molly: "change user's login for dbo user"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
