please!!! very important

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Data Corruption » please!!! very important

14 posts, Page 1 of 2

1 2 »»

please!!! very important

Rate Topic

Display Mode

Topic Options

Author

Message

ambo.php

Posted Tuesday, April 05, 2011 10:58 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, April 09, 2011 10:49 AM
Points: 6, Visits: 6

not speak english ,,, good
Hi All

I Have Sql Server 2000 database

name : Horizon

and if i want to update some tables show this messege :
" Database Error|Integrty trigger failed
id#s are maintained by triggers and cannot be updated otherwise"

how do to solve this proble;

firs time show this messege, i use this database since 4 years until now

ThankYou;

Post #1088772

GSquared

Posted Tuesday, April 05, 2011 11:09 AM

SSCoach

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:55 PM
Points: 15,442, Visits: 9,571

Check for a trigger on the table you're trying to update. It looks like the error is coming from a trigger.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #1088786

ambo.php

Posted Tuesday, April 05, 2011 11:20 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, April 09, 2011 10:49 AM
Points: 6, Visits: 6

how to check table

and I want check all table

Thank you for reply

Post #1088791

SQLRNNR

Posted Tuesday, April 05, 2011 11:20 AM

SSCoach

Group: General Forum Members
Last Login: Today @ 8:43 AM
Points: 18,734, Visits: 12,333

As Gus said, it looks like custom errors being thrown from a trigger on the table.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1088792

GilaMonster

Posted Tuesday, April 05, 2011 11:23 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:47 AM
Points: 37,739, Visits: 30,012

That's not a SQL error. It's coming from some custom code in the database. Are the developers of the database available?

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1088794

ambo.php

Posted Tuesday, April 05, 2011 12:14 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, April 09, 2011 10:49 AM
Points: 6, Visits: 6

i try to check it

but while run check and maintenace

and click start jop

it say : excuting jop step '0 unknown'

thank you all

Post #1088826

SQLRNNR

Posted Tuesday, April 05, 2011 12:19 PM

SSCoach

Group: General Forum Members
Last Login: Today @ 8:43 AM
Points: 18,734, Visits: 12,333

It seems that you are now doing something different. Could you give more details please?

Post #1088828

ambo.php

Posted Tuesday, April 05, 2011 12:25 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, April 09, 2011 10:49 AM
Points: 6, Visits: 6

ok

now i go to database and click right button on mouse

and select maintence plan

and pres next next ... and checked on (check of integrity database) and click next ... and click ok

after this it added a new jop

so that go to jop and start it

after start it show in status : Executing Job Step '0 (unknown)'.

thank you

Post #1088831