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

A New Word: Opia

By

opia – n. the ambiguous intensity of eye contact The entry for this says...

Friday Flyway Tips: Searching a Migration

By

This was actually a cool tip I saw internally from one of the product...

Build Recovery into the Design

By

It's like disaster recovery (and business continuity) planning is the end-of-term research paper that...

Read the latest Blogs

Forums

sqlclient data provider .net provider connection

By jaango123

I have a task to check the connection managers as part of ssis integration...

How

By cw255

Hi, wondering if someone can help me. We're trying to build an application that...

Log Backup failed on Secondary Replica

By aroojsql

I have a scenario where log backup is getting failed in Secondary replica on...

Visit the forum

Question of the Day

Statistics Histograms

I have a statistics objects with 2 key columns from my tables. How many histograms and their type are stored?

See possible answers