November 15, 2004 at 2:35 pm
I have a bunch of DTS Packages which has a specific user name as the object owner. I would like to change the DTS Packages' Owner to dbo. Is this possible? I am able to change the owner to sqlagent. I logged into SQL EM as sqlagent and open/save each package and it defined sqlagent as the package owner. Sqlagent is a member of a W2000 Group which is a member of the sysadmin Fixed Server Role. But, I would like to have dbo as each package owner. (We have SQL Server 2000, SP3.)
Thanks in advance, Kevin
November 15, 2004 at 2:59 pm
Do a forum search here. IIRC, this has been discussed here a few days ago. Otherwise, maybe http://www.sqldts.com has an answer.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 16, 2004 at 10:11 am
Use the undocumented stored procedure msdb.sp_reassign_dtspackageowner. Look at it in Query Analyzer to see the parameters it expects. BTW, a package must be owned by a login, rather than a database user like dbo. You can change the owner to the login that is mapped to dbo.
Greg
Greg
November 22, 2004 at 1:00 pm
I've used the information from the following link to dynamically assign all dts packages with a certain owner, to another owner. It uses the same stored procedure, sdb.sp_reassign_dtspackageowner.
http://www.databasejournal.com/features/mssql/article.php/1461511
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply