DBCC CHECKDB and capture results in table

• JWA

  Old Hand

  Points: 392

  More actions

  June 13, 2006 at 12:44 pm

  #112513

  I am running the following the sql below:

  create table tempdb..DBCCOutput ( id int identity, output  varchar(255) null)

  GO

  insert tempdb..DBCCOutput ([output])

  EXEC master..xp_cmdshell 'isql /d dbnamehere -Q"dbcc checkdb (dbnamehere)" -E'

  GO

  However I am getting the following error msg:

  1           Msg 1934, Level 16, State 1, Server ATLDB12, Line 1

  2           DBCC failed because the following SET options have incorrect settings:

  3           'ANSI_NULLS., CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS, ANSI_PADDING'.

  4           NULL

  I turned on all those options: SET ANSI_NULLS ON .etc...but still the same msg..has anyone run into this problem/error msg before? If so how did u work around it?

  ---

  Kindest Regards,

  JWA

• raj-247939

  SSCertifiable

  Points: 5999

  More actions

  June 13, 2006 at 9:06 pm

  #643538

  did u enbabled these option on database level

   

  HTH

  killer