Thursday, May 5, 2011

Query to change the owner of the DTS package in sqlserver2000:

 DTS Package owner change:

sp_reassign_dtspackageowner

'Package_name’,

‘Package_id’,

'Newownerloginname’



Parameters descriptive:

Package_name ->specify name of the package.

Package_id ->get the id value from below output for the corresponding packages.

use msdb
GO
select * from sysdtspackages

Moreover we can take idvalue for the latest ‘created date’ column from the above table.

No comments:

Post a Comment

MYSQL:::Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables

  Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables Introduction: In the dynamic landscape of database management...