I have an application that needs to import a CSV file into a temp table, then do a bunch of manipulations after that. However, I do NOT want to give the AppID the BULKADMIN server role for bulk import.
So far, the only slightly feasible work around seems to be to have a sysadmin create the import job and have the AppID call a stored procedure with EXEC AS to get the higher level of rights. But that seems needlessly "clunky" to me.
TIA for all assistance!
Clarie