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 12:45 PM


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:41 AM
Points: 42,442, Visits: 35,496
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 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 #1088840
Posted Tuesday, April 5, 2011 12:59 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 11:51 AM
Points: 21,209, Visits: 14,894
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


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 #1088850
Posted Thursday, April 7, 2011 6:16 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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
Post #1089804
Posted Saturday, April 9, 2011 10:50 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
thank for all

i called devloper of program horizon
Post #1091107
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse