>>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'

Ahh cool!