DBCC CHECKCONSTRAINTS

Hi all,
I run a
DBCC CHECKCONSTRAINTS WITH ALL_CONSTRAINTS
on my database, and i am prompted this message :
Server: Msg 8170, Level 16, State 2, Line 1
Insufficient result space to convert uniqueidentifier value to char.
The statement has been terminated.
I have tried to specify a table, and it seems to be caused by a
non-validating foreign key in the uniqueidentifier type.
I have found (on the web and this newsgroup) several posts about this
problem, but nobody gave (or found ?) the explaination/solution.
Can anybody tell me how to solve this problem ?
Thanks
PS :
Hope my frenchy english is clear enough ...
I need this DBCC, so don't explain me how to prevent FK violation ;o).
We have fixed this bug in SP4 for SQL 2000. Have you tried the beta yet? You can sign up at http://support.microsoft.com/default...;en-us;290211. Please let us know if you still have problems.
Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine, DBCC
"SFauvel" <sylvainfauvel@.free.fr> wrote in message news:7a9148e7.0501210833.be22e21@.posting.google.co m...
> Hi all,
> I run a
> DBCC CHECKCONSTRAINTS WITH ALL_CONSTRAINTS
> on my database, and i am prompted this message :
> Server: Msg 8170, Level 16, State 2, Line 1
> Insufficient result space to convert uniqueidentifier value to char.
> The statement has been terminated.
> I have tried to specify a table, and it seems to be caused by a
> non-validating foreign key in the uniqueidentifier type.
> I have found (on the web and this newsgroup) several posts about this
> problem, but nobody gave (or found ?) the explaination/solution.
> Can anybody tell me how to solve this problem ?
> Thanks
> PS :
> Hope my frenchy english is clear enough ...
> I need this DBCC, so don't explain me how to prevent FK violation ;o).