Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

please!!! very important Expand / Collapse
Author
Message
Posted Tuesday, April 5, 2011 10:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, April 9, 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
Posted Tuesday, April 5, 2011 11:09 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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
Posted Tuesday, April 5, 2011 11:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, April 9, 2011 10:49 AM
Points: 6, Visits: 6
how to check table

and I want check all table

Thank you for reply
Post #1088791
Posted Tuesday, April 5, 2011 11:20 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 1:09 PM
Points: 21,251, Visits: 14,955
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


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
Posted Tuesday, April 5, 2011 11:23 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:54 AM
Points: 42,466, Visits: 35,530
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
Posted Tuesday, April 5, 2011 12:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, April 9, 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
Posted Tuesday, April 5, 2011 12:19 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 1:09 PM
Points: 21,251, Visits: 14,955
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


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 #1088828
Posted Tuesday, April 5, 2011 12:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, April 9, 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
Posted Tuesday, April 5, 2011 12:33 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 1:09 PM
Points: 21,251, Visits: 14,955
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


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 #1088834
Posted Tuesday, April 5, 2011 12:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, April 9, 2011 10:49 AM
Points: 6, Visits: 6
yes i do all steps

but i can't give in result

i have in database 748 tables

Post #1088836
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse