On Windows 2000, I frequently have issues mapping drives, telling me about security conflicts or that the drive is already mapped even though it isn't any more. To solve this problem, you need to run the following from the command prompt:
net use * /d
Friday, September 15, 2006
List all DTS Packages in a query
Run this SQL against the msdb database:
SELECT DISTINCT name FROM sysdtspackages
SELECT DISTINCT name FROM sysdtspackages
Exporting Scheduled Task List to txt
This one works in Xp and also 2003 Server..
From the command prompt type:
schtasks > tasks.txt
From the command prompt type:
schtasks > tasks.txt
Subscribe to:
Posts (Atom)