DBO

HI All
does any one know the SQL code to change the ownership of
a database from one user to another say: \\Domain\fred to
SA account.
thanks
ToddTry:
sp_changedbowner 'sa'
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Todd" <anonymous@.discussions.microsoft.com> wrote in message
news:01e801c3dbac$e48efda0$a601280a@.phx.gbl...
HI All
does any one know the SQL code to change the ownership of
a database from one user to another say: \\Domain\fred to
SA account.
thanks
Todd|||Hi Todd
Read about sp_changedbowner in the Books Online.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Todd" <anonymous@.discussions.microsoft.com> wrote in message
news:01e801c3dbac$e48efda0$a601280a@.phx.gbl...

quote:

---

> HI All
> does any one know the SQL code to change the ownership of
> a database from one user to another say: \\Domain\fred to
> SA account.
>
> thanks
> Todd

---