Information générale
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement