Re: change ownership of objects

To add on Hari's reply
Run the output in the QA

SELECT 'EXEC sp_changeobjectowner '''+ROUTINE_NAME+''',''dbo'''
FROM INFORMATION_SCHEMA.ROUTINES
WHERE OBJECTPROPERTY(OBJECT_ID(ROUTINE_SCHEMA+'.'+ROUTINE_NAME),
'IsMsShipped')=0
AND ROUTINE_SCHEMA != 'dbo'





"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: ASP.net insists on using dbo. to call aspnet_* stored procedures
    ... No. mysql_login is one account and the dbo is another account, ... SQL Server 2000 developer in same machine. ... connection string is setup to use the sql login assigned to the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Strange Exception!
    ... >> I'm not sure how you login to enterprise manager as a different account? ... >> When I go in as normal it says that all the tables are owned by dbo. ... > account that is mapped to dbo or log in as 'sa'. ...
    (microsoft.public.dotnet.general)
  • Re: How to drop login name with the dbo account
    ... DBO is a user name in a database ... It must map to an account in the master database. ... > Currently the dbo account contains login name "pfweb_admin". ...
    (microsoft.public.sqlserver.programming)
  • Re: dbo issues
    ... I assume that the database owner is 'sa'. ... dbo user, thus automatically creating 'dbo' owned objects. ... > users included in this Windows Group Account. ...
    (microsoft.public.sqlserver.security)
  • Re: Changing DBO
    ... You need to first change the ownership of the existing objects to 'dbo' ... You can then remove the existing database user ... > I have assigned an SQL account as DBO of a database. ...
    (microsoft.public.sqlserver.security)