errors with DBCC CHECKCONSTRAINTS WITH ALL_CONSTRAINTS, ALL_ERRORMSGS, NO_INFOMSGS

• Simon_L

  SSCarpal Tunnel

  Points: 4669

  More actions

  July 13, 2007 at 10:15 am

  #372778

  When I run

  DBCC CHECKCONSTRAINTS WITH ALL_CONSTRAINTS, ALL_ERRORMSGS, NO_INFOMSGS

  I get

  Server: Msg 8170, Level 16, State 2, Line 1 Insufficient result space to convert uniqueidentifier value to char.

  Server: Msg 8170, Level 16, State 1, Line 1 Insufficient result space to convert uniqueidentifier value to char.

  The statement has been terminated.

  The statement has been terminated.

  (331 row(s) affected)

   

  Any ideas ?!! , wouldnt have thought it was a space issue as plenty of disc space avaible, clutching at straws here !!

  Help si

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  August 9, 2007 at 11:22 pm

  #725896

  Hi

  Do you have any char Foreign key columns pointing to UniqueIdentifier Primary key columns.

  "Keep Trying"

• Simon_L

  SSCarpal Tunnel

  Points: 4669

  More actions

  August 10, 2007 at 6:24 am

  #725963

  Hi , now that I shall have to check

   

  thanks for the advice

   

  si

• Paul Randal

  One Orange Chip

  Points: 29544

  More actions

  September 12, 2007 at 7:12 pm

  #733347

  This is almost certainly a bug in DBCC CHECKCONSTRAINTS - please contact Product Support (http://support.microsoft.com/sql).

  Thanks

  Paul Randal
  CEO, SQLskills.com: Check out SQLskills online training!
  Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
  SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
  Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005