Del,

Please find below text from MSDN library about this command:

"TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and are not transferable."

Cheers,

Zoran




>Hi all:
>
>I'm attempting to issue the TRUNCATE TABLE command from VFP via SQL Pass Thru. When I issue the command, it does not success and I get an error that the user does not have permission to perform this operation on the table in question. In SQL Enterprise Manager, I do not see where I can explicitly grant this permission to a particular user or role.
>
>Will I have to use an administrator level user/role for this? If not, what am I missing?