hx_DTSPackageDetails

,

Displays DTS Package info if any

drop PROCEDURE hx_DTSPackageDetails
go

/* 	Robert Vallee 06/14/2001
	rvallee@hybridx.com
	input:	None
	output:	Table format
	Desc:	Displays DTS Package info if any.
	Warnings: None.
*/

CREATE PROCEDURE hx_DTSPackageDetails AS

set nocount on
SELECT  msdb..sysdtspackages.name AS [DTS Package Name], 
	msdb..sysdtspackages.versionid AS [Version Number], 
	msdb..sysdtspackages.description, 
	msdb..sysdtspackages.createdate, 
	msdb..sysdtspackages.owner, 
	msdb..sysdtspackagelog.starttime, 
	msdb..sysdtspackagelog.endtime, 
	msdb..sysdtspackagelog.elapsedtime,
	msdb..sysdtspackagelog.computer
FROM msdb..sysdtspackages INNER JOIN
	msdb..sysdtspackagelog ON msdb..sysdtspackages.id = msdb..sysdtspackagelog.id

Rate

Share

Share

Rate