Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Changing the Owner of a Single DTS Package

By SQLDev,

This is not an original script - but one I modified from an article by Darren Green on databasejournal.com (02/21/2000).  His original script changed the owner of all DTS packages owned by @old_owner to be owned by @new_owner. 

This script will change the owner of the most recent version of a specific DTS package (@p_name) to be owned by @new_owner.

The stored procedure should be placed in the msdb database and executed from that database.  Example command is:

EXEC sp_DTSReplaceOwner
@p_name = 'package name',
@new_owner = 'MyDomain\OwnerName'

Total article views: 485 | Views in the last 30 days: 1
 
Related Articles
FORUM

How to change Owner of a package

How to change Owner of a package

FORUM

how to find out dts package owner

how to find out dts package owner

FORUM

How can I change the owner of an SSIS Package?

How can I change the owner of an SSIS Package?

FORUM

scripting a database without db owner permissions

scripting a database without db owner permissions

BLOG

A Script A Day - Day 5 - Database Owner Permissions

Today's script will list all principals with membership in the db_owner fixed database role. /*...

 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones