>>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?
>
>
>Jeff,
>
>You can make each user impersonate the DBO by giving each login an Alias (of the DBO's login).
>
>Valerie

Thanks Valerie, but I don't think that would work. The DBO is the SA.

Jeff