Re: Error from Maintenance plan
From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 08/30/04
- Next message: Wayne Snyder: "Re: How to Move SQL System Databases"
- Previous message: SQLCatz: "Re: Examples for these ~ Thank You."
- In reply to: John Boghossian: "Error from Maintenance plan"
- Next in thread: Aaron [SQL Server MVP]: "Re: Error from Maintenance plan"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 30 Aug 2004 07:41:59 -0400
John,
Go with TIbors suggestions.... A computed column which is index, etc , then
those settings matter during maint plan stuff... I would suspect you are
getting the error on index rebuild..
-- Wayne Snyder, MCDBA, SQL Server MVP Mariner, Charlotte, NC www.mariner-usa.com (Please respond only to the newsgroups.) I support the Professional Association of SQL Server (PASS) and it's community of SQL Server professionals. www.sqlpass.org "John Boghossian" <john.boghossian@investorab.com> wrote in message news:eS2iwyljEHA.3724@TK2MSFTNGP11.phx.gbl... > Hi there, > > I get an error from the maintenance plan, when it every weekend reorganizes > the data and index tables: > > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL > Server Driver][SQL Server]DBCC failed because the following SET options have > incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'. > > I wonder if it could be because i have an calculated field in the table, > [FullName] AS ([LastName] + ', ' + [FirstName]) ? > > > The table is create as follows: > > CREATE TABLE [dbo].[Assigner] ( > [id] [int] IDENTITY (1, 1) NOT NULL , > [FirstName] [varchar] (25) COLLATE SQL_SwedishStd_Pref_CP1_CI_AS NOT NULL , > [LastName] [varchar] (30) COLLATE SQL_SwedishStd_Pref_CP1_CI_AS NOT NULL , > [FullName] AS ([LastName] + ', ' + [FirstName]) , > [CustomerGroup_id] [int] NOT NULL , > [Deactivated] [bit] NULL > ) ON [PRIMARY] > GO > > ALTER TABLE [dbo].[Assigner] WITH NOCHECK ADD > CONSTRAINT [PK_Assigner] PRIMARY KEY CLUSTERED > ( > [id] > ) WITH FILLFACTOR = 70 ON [PRIMARY] > GO > > ALTER TABLE [dbo].[Assigner] ADD > CONSTRAINT [FK_Assigner_CustomerGroup] FOREIGN KEY > ( > [CustomerGroup_id] > ) REFERENCES [dbo].[CustomerGroup] ( > [id] > ) > GO > >
- Next message: Wayne Snyder: "Re: How to Move SQL System Databases"
- Previous message: SQLCatz: "Re: Examples for these ~ Thank You."
- In reply to: John Boghossian: "Error from Maintenance plan"
- Next in thread: Aaron [SQL Server MVP]: "Re: Error from Maintenance plan"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
