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


lnTResult = SQLEXEC(lnYourConnectionHandle,'TRUNCATE TABLE ' + lcYourTableName,'curYourOutPut',aCountInfo)

IF lnTResult = 1
* Truncate worked *
Else
* Truncate failed *
EndIf