Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Permission to TRUNCATE TABLE
Message
 
À
09/12/2003 16:16:56
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Sécurité
Divers
Thread ID:
00857388
Message ID:
00857624
Vues:
25
>Do you have FK's in this table? It may be due to that. Can you do a
>
>DELETE FROM MyTable

This seems to be the problem. DELETE FROM does work on all three of my tables. I'd prefer the deletes not be logged in this case, but I'll live.

One of the tables actually did not contain a fk, but it was the parent of the other two tables. I see now the help mentions the issue with fk's. It's intuitive why a parent table would also not be allowed to be truncated, although it does not contain a fk. I guess this is why the help uses the wording "referenced by a foreign key," which at first glance I thought was poorly stated.

Thanks...
Del
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform