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/defaul...b;en-us;290211. Plea
se 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.com...
> 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).
No comments:
Post a Comment