Posted by Erland Sommarskog on 02/16/07 22:29

berwiki (steveberwick@gmail.com) writes:
> 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)


For the stored procedures do:

SELECT 'EXEC sp_changeobjectowner ''' + name + ''', '''dbo''''
FROM sysobjects
WHERE uid = USER_ID('co-worker')

copy, paste and run result set. This will take care of stored procedures,
tables etc. Note that any references to these procedures from elsewhere will
need to be updated.

I have never worked with DYS, so I cannot answer that part.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: T-SQL in Mngmt Studio Express Doesnt affect change- obvious omission?
• Prev in forum: Re: Sql server process memory question
• Thread view: Re: Change Object Ownership

[Reply to this message]