Technical Article

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) […]

You rated this post out of 5. Change rating

2002-10-29

493 reads

Blogs

When It’s Still Viable

By

If a technology is still viable, don’t overlook it. Don’t get caught up chasing...

T-SQL Tuesday #179: The Detective’s Toolkit

By

It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend,...

Moving T-SQL Tuesday to Jekyll

By

I got a message a few months back that Microsoft was deprecating the MySQL...

Read the latest Blogs

Forums

case statement with and like operators

By Wren

Hello, I'm trying to remove results from this sql statement where the custid like...

update error. Subquery returned more than 1 value

By reza.asali

Hi friends. how can i fix that? ;with cte as (select distinct(e.Id ) from...

THE CSV PROBLEM

By fk.da

Hello everyone, First of all, thank you very much for this great community. I...

Visit the forum

Question of the Day

Data Migration Assistant Targets

In the current (2024) version of the Data Migration Assistant, which on-premises targets are available?

See possible answers