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).This is a multi-part message in MIME format.
--=_NextPart_000_007F_01C4FFB4.8F43D500
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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.aspx?scid=3Dkb;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.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).
--=_NextPart_000_007F_01C4FFB4.8F43D500
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
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.aspx?scid=3Dkb;en-us;290211.&nb=sp; Please let us know if you still have problems.
Thanks,
Ryan StonecipherMicrosoft SQL Server Storage =Engine, DBCC
"SFauvel"
--=_NextPart_000_007F_01C4FFB4.8F43D500--
No comments:
Post a Comment