> 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.
Previous
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