General information
Title:
MS SQL Server stored procedures
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only