>Hi,
>
>Is it possible to determine (from a VFP application) if a user has SQL Server permission to Truncate a table? TIA.
>
>UPDATE: Or at least how to determine from the error number returned when executing Truncate table command that the problem was due to the user permission to Truncate?

See http://stackoverflow.com/questions/6063451/truncate-table-permissions

and then

http://sqltips.wordpress.com/2007/05/28/retreive-current-user-permissions-in-sql-server-2005/

So, you can run

if exists (select 1 from fn_my_permissions('MyTableName', 'object') where PERMISSION_NAME = 'ALTER')
  print 'Can truncate table'
ELSE
  print 'Do not have permissions to truncate table'