Change DTS package owner

This simple script is useful if you have a lot of scripts owned by developers, and you want to re-assign them all in one go to SA or any other login. Note the section which produces a rollback if you have any problems after the re-assign

4 (2)

2007-09-27 (first published: )

2,368 reads

Blogs

Use Jupyter Notebooks to Help People on StackOverFlow

By

I am sat in the PowerShell Saturday in Hamburg. You can see me on...

ACM Lecture at SELU

By

Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...

T-SQL Copy & Paste Pattern – Increasing a performance problem

By

Disclaimer: The title is my assumption because I saw it in the past happening...

Read the latest Blogs

Forums

FILEGROUP ... CONTAINS MEMORY_OPTIMIZED_DATA' failed because it is not supported

By 89netanel

Hi all, I have: Microsoft SQL Server 2016 (RTM-GDR) (KB4019088) - 13.0.1742.0 (X64) Jul...

Export-CSV with the path as a variable

By samirca007

Good morning all I'm looking to export the result of the execution of a...

Always on synchronous

By MVDBA (Mike Vessey)

In the past I've used database mirroring in high safety mode and always fallen...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers