Displays DTS Package info if any
2001-08-22
714 reads
Robert-Vallee,
2001-08-22
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
You rated this post out of 5. Change rating
2001-08-22
714 reads
2001-08-22
366 reads
Very simple, how much space is free on the hard drives of the SQL Server you are connected to.
2001-08-22
652 reads
Get OLE Providers info I have found this useful in tracking down application driver/connection issues. I only had to use it 2 times. But it did help
2001-08-22
399 reads
2001-08-22
699 reads