MS SQL Server stored procedures
Save to folder
I created a VFP 5.0 front-end application for a MS SQL Server database. My application currently has code that deletes all the records in a table and the appends new data to this table. Using SQL DELETE is slow and creates a large log file. I created a SQL Server stored procudure as the System Administrator that truncates the table. This is very fast and does not effect the log. My problem is this: even though I granted user rights to execute the stored procedure, the procedure fails stating that only the database owner or SA can truncate a table. Is there anyway around this?