Change DTS package owner
There is a un-documented stored procedure in msdb called sp_reassign_dtspackageowner. Unfortunately, this requires a package name and will only work on one at a time. If one developer is taking over for another, it may be helpful to change all of Bob's dts packages over to Jim. The following procedure will do just that.Not sure […]
2002-08-05
448 reads