Changing login for dbo object (SQL Server 2000)

I've got a SQL Server 2000 database (ASOQA) that has the dbo User linked to
my Windows-based domain login. This has been causing me problems when tryin
g to add permissions to my account; I get an error that I can't make any cha
nges to the dbo object.
The fix, as I understand it, is to change the dbo User to use the sa login a
nd add another administrative User for my Windows-based login. I note that
a companion database on the same server is setup that way and I have no prob
lems with assigning roles on that one. I was directed to use sp_change_user
s_login but that also produces errors stating that the dbo object is invalid
for the User parameter.
Basically, here's what I see now for users in Enterprise Manager on ASOQA:
Name Login Name
dbo noe\ranarnol *
dev dev
reportuser reportuser
(etc)
Here's how the other database is setup, and how I want ASOQA done:
Name Login Name
dbo sa *
dev dev
ranarnol noe\ranarnol *
reportuser reportuser
(etc)
noe\ranarnol is my usual login. Any ideas how I go about accomplishing this
?
Thanks,
Randall ArnoldIt sound like what you are looking for is sp_changedbowner.
In Query Analyzer, change your database context to the
database you are having problems with and execute:
sp_changedbowner 'sa'
-Sue
On Tue, 16 May 2006 11:27:25 -0500, "Randall Arnold"
<randall.nospam.arnold@.nospamnokia.com.> wrote:

>I've got a SQL Server 2000 database (ASOQA) that has the dbo User linked to
my Windows-based domain login. This has been causing me problems when tryi
ng to add permissions to my account; I get an error that I can't make any ch
anges to the dbo object.
>The fix, as I understand it, is to change the dbo User to use the sa login and add
another administrative User for my Windows-based login. I note that a companion dat
abase on the same server is setup that way and I have no problems with assigning rol
es
on that one. I was directed to use sp_change_users_login but that also produces errors stat
ing that the dbo object is invalid for the User parameter.
>Basically, here's what I see now for users in Enterprise Manager on ASOQA:
>Name Login Name
>dbo noe\ranarnol *
>dev dev
>reportuser reportuser
>(etc)
>Here's how the other database is setup, and how I want ASOQA done:
>Name Login Name
>dbo sa *
>dev dev
>ranarnol noe\ranarnol *
>reportuser reportuser
>(etc)
>noe\ranarnol is my usual login. Any ideas how I go about accomplishing thi
s?
>Thanks,
>Randall Arnold|||Thanks, Sue, I'll give it a shot!
Randall
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:jl9k62p4ipgkbppvhglaqlbkgsnpt745fo@.
4ax.com...
> It sound like what you are looking for is sp_changedbowner.
> In Query Analyzer, change your database context to the
> database you are having problems with and execute:
> sp_changedbowner 'sa'
> -Sue
> On Tue, 16 May 2006 11:27:25 -0500, "Randall Arnold"
> <randall.nospam.arnold@.nospamnokia.com.> wrote:
>
>|||Worked like an absolute charm! Exactly what I needed! Thanks again.
Randall
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:jl9k62p4ipgkbppvhglaqlbkgsnpt745fo@.
4ax.com...
> It sound like what you are looking for is sp_changedbowner.
> In Query Analyzer, change your database context to the
> database you are having problems with and execute:
> sp_changedbowner 'sa'
> -Sue
> On Tue, 16 May 2006 11:27:25 -0500, "Randall Arnold"
> <randall.nospam.arnold@.nospamnokia.com.> wrote:
>
>|||Your welcome Randall - thanks for posting back!
-Sue
On Wed, 17 May 2006 15:05:12 -0500, "Randall Arnold"
<randall.nospam.arnold@.nospamnokia.com.> wrote:

>Worked like an absolute charm! Exactly what I needed! Thanks again.
>Randall
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:jl9k62p4ipgkbppvhglaqlbkgsnpt745fo@.
4ax.com...
>