>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
ICQ 10556 (ya), 254117