I have a semi complicated Stored procedure running that uses a variety of Extended Stored procedures and extras.
I understand that only a sysadmin user can run master..xp_cmdshell, so I have set up the proxy account and given sysadmin to that. cmdshell does seem to work now.
I think the problem is with the BULK INSERT. I have set the user windows group to be BULK INSERT ADMINISTRATORS but everytime the stored proc is run it fails.
I have set them up as sysadmin for a test and it works fine.
SQL 2000 SP3a is running
Access 2000 Front End
Any help would be appreciated. Maybe even a way to set User as sysadmin just while the stored proc runs? Possible?