how to change db owner in SQL Server 2000

Hi,
we have created a new database in SQL Server 2000 and need
to change the database owner of the database to another
user.
Can someone help?
Thanks for reply.
Bodobodo
Please refer to BOL for sp_changedbowner.
> Hi,
> we have created a new database in SQL Server 2000 and need
> to change the database owner of the database to another
> user.
> Can someone help?
> Thanks for reply.
> Bodo|||Hi,
is it also possible to change dbo in the Enterprise
Manager, without having to go into SQL programming?
Thanks for reply.
Bodo
>--Original Message--
>bodo
>Please refer to BOL for sp_changedbowner.
>
>> Hi,
>> we have created a new database in SQL Server 2000 and
need
>> to change the database owner of the database to another
>> user.
>> Can someone help?
>> Thanks for reply.
>> Bodo
>
>.
>|||AFAIK, there is no GUI method to change the database owner. Howerver,
the T-SQL script to accomplish the task is fairly simple:
USE MyDatabase
EXEC sp_changedbowner 'MyDatabaseOwner'
GO
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"bodo" <bodobecker@.hotmail.com> wrote in message
news:00b601c36ff8$e7706060$a601280a@.phx.gbl...
> Hi,
> is it also possible to change dbo in the Enterprise
> Manager, without having to go into SQL programming?
> Thanks for reply.
> Bodo
> >--Original Message--
> >bodo
> >Please refer to BOL for sp_changedbowner.
> >
> >
> >
> >> Hi,
> >>
> >> we have created a new database in SQL Server 2000 and
> need
> >> to change the database owner of the database to another
> >> user.
> >>
> >> Can someone help?
> >>
> >> Thanks for reply.
> >>
> >> Bodo
> >
> >
> >.
> >|||Hi Dan,
sorry for asking you for help again - you know I am new to
SQL Server but I want to learn it.
Can you tell me where to find the interface where I can
type in the code you gave me?
Thanks for reply.
Bodo
>--Original Message--
>AFAIK, there is no GUI method to change the database
owner. Howerver,
>the T-SQL script to accomplish the task is fairly simple:
> USE MyDatabase
> EXEC sp_changedbowner 'MyDatabaseOwner'
> GO
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>--
>SQL FAQ links (courtesy Neil Pike):
>http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
>http://www.sqlserverfaq.com
>http://www.mssqlserver.com/faq
>--
>"bodo" <bodobecker@.hotmail.com> wrote in message
>news:00b601c36ff8$e7706060$a601280a@.phx.gbl...
>> Hi,
>> is it also possible to change dbo in the Enterprise
>> Manager, without having to go into SQL programming?
>> Thanks for reply.
>> Bodo
>> >--Original Message--
>> >bodo
>> >Please refer to BOL for sp_changedbowner.
>> >
>> >
>> >
>> >> Hi,
>> >>
>> >> we have created a new database in SQL Server 2000 and
>> need
>> >> to change the database owner of the database to
another
>> >> user.
>> >>
>> >> Can someone help?
>> >>
>> >> Thanks for reply.
>> >>
>> >> Bodo
>> >
>> >
>> >.
>> >
>
>.
>