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 […]

5 (1)

2002-08-05

442 reads

Blogs

Event Log File Paths

By

How does one consistently find the correct path to the Extended Event Log file...

Clearing an Email from the Microsoft Directory

By

Years ago I was working on a demo with Microsoft and someone added me...

Learning Containers

By

I find that I’m using containers more and more to get things done with...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

DBA Walkthrough – Adding space on IBM AIX Power Machines

By SOLVARIA

Comments posted to this topic are about the item DBA Walkthrough – Adding space...

The Datatimeoffset Value

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Datatimeoffset Value

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers