> 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? I think the only way to do this is to either a) alias the user as dbo or sa (not a great idea (g)) or b) make that user a domain admin (automatically aliases as sa, not a good idea either). It really depends on how much you trust your user(s), I suppose. 'dbo' isn't always a bad thing..... The other (obvious0 option is to increase the size of your log (I further assume the log is on a seperate device form your database, right?). HTH, Scot.