hx_DTSPackageDetails

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