On SQL Server 2000, you can schedule a DTS package to run as a job through the SQL Server Agent. The Agent will allow you to specify the user under which to run the job and the schedule to use. However, I have not done this myself, so I can't provide the details. Eric A. Laney Systems Architect Verizon Security "Reading maketh a full man, conference a ready man, and writing an exact man." -- Francis Bacon (1561-1626) from 'Of Studies', 1625
______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
