Re: change ownership of objects

To add on to my previous post to change DTS owner use:-

use msdb
go
sp_reassign_dtspackageowner [@name =] 'name',[@id =] 'id',[@newloginname =]
'newloginname'


Thanks
Hari

"Hari Prasad" <hari_prasad_k@xxxxxxxxxxx> wrote in message news:...
Hello,

Fiirst of all change the password for his account to a one with special
charecters, so as no one can access. After that you could use
sp_changeobjectowner system proc to change the owner of all object from
that user to DBO. take
alook into sp_changeobjectowner in books online..Once you completed the
object owner to DBO you could drop the user and
login associated.

Thanks
Hari

"berwiki" <steveberwick@xxxxxxxxx> wrote in message
news:1171656219.472511.150980@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
A co-worker recently quit the company, and all of his stored
procedures and DTS packages are apparently under his name. Is there
any way to change his account to another (ie administrator or SA)??

I am afraid to delete his account in fear all the stored procedures
will be lost. (we have backups, but ... ugh)


(running mssql server 2000)





.

Relevant Pages

  • Re: Nmae of Profile in XP Home
    ... Settings, its name is not Daave, but rather it is still Owner. ... The correct way really is to immediately abandon the Owner profile ... To change the name of your Documents and Settings\UserName folder: ... 1- Log on to your account and use the SET USERPROFILE command to ...
    (microsoft.public.windowsxp.general)
  • Re: Swen Virus
    ... used in an NNTP post by the owner, that he is getting swamped, as you are, ... and the poor sap is getting bounces back to his address ... from automated systems that don't care if it is a forgery. ... I have only sent three manual requests for confirmation from the account ...
    (microsoft.public.security.virus)
  • Re: User accounts
    ... Just copy over the ones you want to your own folder. ... "owner" folder (the system does not allow for renaming of the user account ... If your account is using the "jack" username folder, ... Windows help - www.rickrogers.org ...
    (microsoft.public.windowsxp.newusers)
  • Re: I am unable to switch ownership of files in a prior C: Hard drive
    ... Home didn't have the SECURITY tab in Explorer properties. ... You needed PRO to take ownership of files. ... owner and edit and changed the owner to that of my VISTA administrator ... account by selecting as a new owner my new admin account, ...
    (microsoft.public.windows.vista.administration_accounts_passwords)
  • Re: Nmae of Profile in XP Home
    ... Settings, its name is not Daave, but rather it is still Owner. ... The correct way really is to immediately abandon the Owner profile ... To change the name of your Documents and Settings\UserName folder: ... 1- Log on to your account and use the SET USERPROFILE command to ...
    (microsoft.public.windowsxp.general)