Groups will not work in this instance, you'll need to assign a databaseQuote:> I want to change the db owner for a database to a windows
> group that a found by executing sp_helplogins:
> sp_changedbowner 'domain\windowsusergroup'
> The query analyzer refuses, and says that the login
> doesn't exist. Is it not possible to make a winusergroup a
"owner" that is a user login account.
You could, but then that will likely lead to referencing issues as allQuote:> It is possible to put my WIN2000 login as the owner, could
> that cause any problem? What happens when I quit for
objects in the database will owned under your account. Broken or orphaned
ownership chains are common with this scenario. You may want to consider
keeping the owner as 'sa'...