View Single Post
  #2 (permalink)  
Old October 17th, 2005, 09:30 PM
robprell robprell is offline
Friend of Wrox
 
Join Date: Aug 2004
Location: Orange County, CA, USA.
Posts: 385
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am not sure I follow the issue. Create a user account that has the rights to run the batch file. Have the job run as that user and make sure that user has the needed rights in SQL. But this is a rather unsecure method, but most are in MS development using DTS and/or Batch files.

Hope this helps

Reply With Quote