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
ToddThis is a multi-part message in MIME format.
--=_NextPart_000_049E_01C3DB83.94E41480
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Try:
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
--=_NextPart_000_049E_01C3DB83.94E41480
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Try:
sp_changedbowner 'sa'
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Todd" wrote in message news:01e801c3dbac$e4=8efda0$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
--=_NextPart_000_049E_01C3DB83.94E41480--|||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...
> 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
No comments:
Post a Comment