Changing the Owner of a Single DTS Package

This is not an original script - but one I modified from an article by Darren Green on databasejournal.com (02/21/2000).  His original script changed the owner of all DTS packages owned by @old_owner to be owned by @new_owner.  This script will change the owner of the most recent version of a specific DTS package (@p_name) […]

2002-10-29

491 reads

Blogs

Career: Talk To References

By

As we try to get through these strange times in the world, I am...

This Saturday: #DataWeekender, DataSaturday Southwest

By

Geeked to be speaking 2x on Saturday May 14, my second time speaking at...

Daily Coping 14 May 2021

By

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

Read the latest Blogs

Forums

Why doesn't the Secondary failover?

By FrankFarquar

Hi, I hope someone can help. I will try to summarise as best as...

How to rewrite sql query after where condition with another query ?

By ahmed_elbarbary.2010

I work on sql server I need to rewrite statement after where statement so...

Incorrect syntax near the keyword 'AS'

By basmster

Hi Everyone. I'm hoping someone can take a look at my code here to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Container Logs

See possible answers