please!!! very important

Question

please!!! very important

ambo.php

Valued Member

Points: 70
More actions
April 5, 2011 at 10:58 am

#235078

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;

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

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

ambo.php Valued Member Points: 70 More actions · Answer 2

how to check table

and I want check all table

Thank you for reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

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, MVP, M.Sc (Comp Sci)
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

ambo.php Valued Member Points: 70 More actions · Answer 5

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

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

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

ambo.php Valued Member Points: 70 More actions · Answer 7

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

it looks like an incomplete maint plan was created. Did you verify the job steps inside the job?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

ambo.php Valued Member Points: 70 More actions · Answer 9

yes i do all steps

but i can't give in result

i have in database 748 tables

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 10

ambo.php (4/5/2011)
i try to check it
but while run check and maintenace
and click start jop
it say : excuting jop step '0 unknown'

Why are you running a maintenance plan? The error is not telling you the database is corrupt. The error is coming from a trigger that one of the people who developed the database put in place. It is not coming from SQL Server.

You need to either find the trigger or speak to the people who developed the database structure.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

GilaMonster (4/5/2011)
ambo.php (4/5/2011)
i try to check it
but while run check and maintenace
and click start jop
it say : excuting jop step '0 unknown'
Why are you running a maintenance plan? The error is not telling you the database is corrupt. The error is coming from a trigger that one of the people who developed the database put in place. It is not coming from SQL Server.
You need to either find the trigger or speak to the people who developed the database structure.

No need to run the maint plan for this error as gail as said. Find the trigger first.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

GSquared SSC Guru Points: 260824 More actions · Answer 12

When you click on the table in Management Studio or Query Analyzer, it should give you a tree that has a Triggers section. Check there.

- 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

ambo.php Valued Member Points: 70 More actions · Answer 13

ambo.php

Valued Member

Points: 70

April 9, 2011 at 10:50 am

#1309559

thank for all

i called devloper of program horizon