Technical Article

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,373 reads

Blogs

Daily Coping 27 Jan 2023

By

Today’s coping tip is to try something new to get out of your comfort...

Things to look out for while TDE is encrypting existing data

By

Monitoring for Problems The encryption of your existing data occurs as a background process...

Daily Coping 26 Jan 2023

By

Today’s coping tip is to focus on what’s good, even if today feels tough....

Read the latest Blogs

Forums

christina home care food pantry

By carecentrefoodpantry

Please donate healthy food to christina home care food pantry You are welcome to...

View Or Stored Procedure

By yrstruly

Please see my DDL. I would like to create: a) Dimensional table that tracks Primary...

Context_Info across databases

By micaden

I have a stored procedure that works across databases.  So the "integration" database will...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers