General information
Forum:
Microsoft SQL Server
>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?
Do you have FK's in this table? It may be due to that. Can you do a
DELETE FROM MyTable
??
BOb
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only