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

First Time Speaking at PASS Summit

By

This week, I filmed my experience as a first time speaker at PASS Summit...

Azure SQL Best Practices?

By

A way to enforce good practice and standards is by Azure Policy. As stated...

Azure Data Studeo- Nov 2019 Release

By

SQL Server Management studio is now can be installed separately not part of SQL...

Read the latest Blogs

Forums

0 Rows Affected - Requires a value Returned

By Buddy84

Hi, I'm currently using Zabbix Monitoring and when connecting via ODBC, I'm executing the...

multi-subnet failover sql cluster

By vsamantha35

Hi All, Have a question related for multi-subnet AG. Trying to understand behaviour of...

Multi select parameter does not work in WHERE clause

By CopWorker

Hello, I´m using a SyBase SQL Anywhere 17 Database. Then I want to create...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers