Friday, September 15, 2006

net shares and login credentials

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

List all DTS Packages in a query

Run this SQL against the msdb database:

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