Re: Who should be owner if bd?

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/22/04

  • Next message: Li: "Error 242, Severity : 16, State : 3" 
    Date: Thu, 22 Jul 2004 08:57:48 +0530

    Thanks Dan. Typo error.

    Regards
    Hari

    "Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
    news:#h$9oE5bEHA.3904@TK2MSFTNGP12.phx.gbl...
    > 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?
    > > >
    > >
    > >
    >
    >

  • Next message: Li: "Error 242, Severity : 16, State : 3"

    Relevant Pages

    • Re: Check database healthiness on a daily basis?
      ... > Thanks so much for your instance response, Hari. ... DBCC CHECKDB will run for a long time if your database is ... >> Monthly once check the fragmentation of table using DBCC ... >> THis will remove the fragmentation and increase the performance. ...
      (microsoft.public.sqlserver.server)
    • Re: is it possible to move table(s) from one db to another?
      ... Well Hari. ... > It seems tin needs to move the table from one database to another ... Script out all the data using available third party tools and script ... >> Vinod Kumar ...
      (microsoft.public.sqlserver.server)
    • Re: SQL 2000 and NTFS
      ... who gains access to the file can reattach the database ... Shouldn't there be a warning that NTFS permissions should ... >I thought the problem was inside SQL Server. ... >Hari Prasad. ...
      (microsoft.public.sqlserver.security)
    • Re: Can you hide a database structure?
      ... along with SQL DE. ... Anyone with admin rights on the machine will be able to ... "Hari Prasad" wrote: ... > Do not give access to that database to any users. ...
      (microsoft.public.sqlserver.msde)
    • Re: Regarding Suspect Database
      ... Hari, One question here... ... Start the database in Emergency mode, ... master..sysdatabases table for that database to 32768. ... >> create a new database and use DTS to transfer objects and data. ...
      (microsoft.public.sqlserver.clients)