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).
Showing posts with label prompted. Show all posts
Showing posts with label prompted. Show all posts
Tuesday, February 14, 2012
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).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" 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--
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--
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/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).
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).
Subscribe to:
Posts (Atom)