Re: Who should be owner if bd?

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 07/22/04 

Date: Wed, 21 Jul 2004 21:11:10 -0500

Hari, perhaps you meant sp_changedbowner? 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:%23P3uvf0bEHA.796@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> It should not be a problem. Only thing is change the database owner (Use
> sp_dbchangeowner)
> incase the administrator drops/renames the nt login currently owns the
> database.
>
> Thanks
> Hari
> MCDBA
>
> "Laura" <anonymous@discussions.microsoft.com> wrote in message
> news:150901c46f31$01a8d920$a601280a@phx.gbl...
> > I restored the databse on the SQL 2000 server and was
> > logged in to the server under my NT account (it is an
> > Admin account).  Now the owner of the database is my NT
> > account.
> > Should the owner really be sa?
> >
>
>

Relevant Pages

  • Re: moving sql data
    ... thanks hari for answer. ... > After setting up the database you can change the server name using the ... > SQL Server MVP ... >> does somebody know if i can transfer system databases ...
    (microsoft.public.sqlserver.setup)
  • Re: sp_trace_create problem
    ... But I can't give access to that account on my machine. ... on server folder. ... Please check the operating system services, ... > SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: How to add a login with Win XP Home workgroup and without domains.
    ... where server was installed, but not others in workgroup. ... A kludge you might try is to create an account with the same and password on the SQL box and then add the local account. ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: How to make a select to another database using sp_addlinkedserver?
    ... In Link server you could also use OPEN QUERY to query the databases ... Hari ... SQL Server MVP ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL7 to SQL2000 and hardware upgrade
    ... SQL Server MVP ... >I have a new box with W2003 Server to replace our existing W2000 ... Prev by Date: ...
    (microsoft.public.sqlserver.setup)