|
-
Feb 1st, 2008, 05:30 PM
#1
[RESOLVED] SQL Server 2005 Truncate Table
On my server at home, I get this error when I try to truncate a table:
Cannot truncate table 'dbo.*****' because it is being referenced by a FOREIGN KEY constraint.
Yes, it is referenced with a foreign key, but there is no data in the other table ! so there is nothing to complain about !
I have simmilar table structure at on the servers at work, and when I do that it does not complain...
There must be a setting somewhere to make it check if there are actually records in the other table, but where ?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|