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

443 reads

Blogs

Daily Coping 8 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Don’t be afraid of No

By

How many times have you been afraid to hear “No”? We have all been...

Spark .NET - Spark ML TF-IDF

By

Spark ML in .NET for Apache Spark Spark is awesome, .NET is awesome, machine...

Read the latest Blogs

Forums

Indexing in a Merge Replication environment

By pssudarshan

Hello SQL Gurus I am new to Database design.  We are building an application...

compare row data

By abhas

Hi , I am having table in below format. I want to calculate difference...

Adding a Calculated Column in R

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding a Calculated Column in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers