andy.westgate (1/25/2013)
We have someone who executes a batch job the result of which is some data is moved from txt files into sql tables based on a couple of bits of info entered by the user when prompted in the batch job.The user's permissions have been removed on this sql database to insert data into these tables.
My question would be, can I just execute the batch job from with in a stored proc or would I run into the same permissions issues? Can the user enter info when the user executes a batch file from a sp? Or would I be better off getting rid of the job and using bulk insert or something instead? I would prefer the former.
Thanks in advance for any information.
Andy
Actually, no. The reason is that there's "info entered by the user when prompted in the batch job". Batch jobs executed from SQL Server cannot be "interactive".
--Jeff Moden
Change is inevitable... Change for the better is not.