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

Azure Cosmos DB: real-time data movement using Change Feed and Azure Functions

By

In this article, we will focus on creating a data pipeline to ETL (Extract,...

Quick 6 month check – how are those learning goals going…?

By

So in January I wrote a blog post on some goals I had this...

Read the latest Blogs

Forums

Error: 17892 Severity: 20 State: 1

By ismahar

Hi, I've been struggling for 5 days to solved this issue. We have a...

Mass replace of DB codes

By berki

Hi, I have a column in a table that contains variable semi-colon DB codes...

Changing Hardware

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Changing Hardware

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Intersection

See possible answers