Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Permission to TRUNCATE TABLE
Message
 
 
To
09/12/2003 16:16:56
General information
Forum:
Microsoft SQL Server
Category:
Security
Miscellaneous
Thread ID:
00857388
Message ID:
00857624
Views:
26
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform