Posted by mplpost on 05/16/07 06:28

Thanks for the reply.

> Was the database originally created on the same server or on a different
> server? Who is the owner of the original database?

The Database was created on the same server. The owner of the original
database is 'sa'.

> > We are using SQL Server 2005 Enterprise Edition
>
> Which Service Pack are you on? (There is some new commands in SP2
> that may be useful.)

No service pack yet applied, its RTM. Pls suggest the commands in SP2,
will try it out.


> You could put ALTER AUTHORISZATION in a stored procedure that is signed
> by a certificate, and then you grant a login created from that certificate
> the rights change database owner. That login is not a real login that
> can actually connect. For more information about this, see an article
> on my web site:http://www.sommarskog.se/grantperm.html.

Will go throught the site, thanks.

Thanks,
MPLPost

• Next in forum: Re: approach to creating a procedure that contains dll , dml to upgrade a system
• Prev in forum: Re: select 'message'; not appearing
• Thread view: Re: Database Owner cannot connect

[Reply to this message]