Trigger Guide

07/19/2015 09:30 Dev.Ahmed_Elnashary#1

i added produce and some lines for auto equip ? with out _TR_AUTOEQUIP_DEPIEDRA[Trigger] i got crash when i press start ?!

any one can help me ?!

where i can find Trigger File in SQL ?! or any one can give me ?

_TR_AUTOEQUIP_DEPIEDRA[Trigger]
? ? ?

and this is my dump file error ? when i got crash

[Only registered and activated users can see links. Click Here To Register...]

pump !

07/20/2015 05:56 Aaron*#2

Explain your problem clearly please and I'll help you.

07/20/2015 22:57 Eslam Galull#3

as Leonius asks you to explain the problem more ,,

and btw you can change that old autoequipments to a new smart one to

07/20/2015 23:37 witchymoo#4

Quote:

Originally Posted by Dev.Ahmed_Elnashary

where i can find Trigger File in SQL ?! or any one can give me ? _TR_AUTOEQUIP_DEPIEDRA[Trigger]

Finding trigger:

Code:

USE [SRO_VT_SHARD]
SELECT [so].[name] AS [trigger_name], USER_NAME([so].[uid]) AS [trigger_owner], USER_NAME([so2].[uid]) AS [table_schema], OBJECT_NAME([so].[parent_obj]) AS [table_name], OBJECTPROPERTY( [so].[id], 'ExecIsUpdateTrigger') AS [isupdate], OBJECTPROPERTY( [so].[id], 'ExecIsDeleteTrigger') AS [isdelete], OBJECTPROPERTY( [so].[id], 'ExecIsInsertTrigger') AS [isinsert], OBJECTPROPERTY( [so].[id], 'ExecIsAfterTrigger') AS [isafter], OBJECTPROPERTY( [so].[id], 'ExecIsInsteadOfTrigger') AS [isinsteadof], OBJECTPROPERTY([so].[id], 'ExecIsTriggerDisabled') AS [disabled]  FROM sysobjects AS [so] INNER JOIN sysobjects AS so2 ON so.parent_obj = so2.Id WHERE [so].[type] = 'TR'

You will get your trigger there, do that to all database you want to check. That one works for SRO_VT_SHARD (as in example)

You should get something like this:
[Only registered and activated users can see links. Click Here To Register...]

good luck

07/20/2015 23:42 Dev.Ahmed_Elnashary#5

Quote:

Originally Posted by its.soul

as Leonius asks you to explain the problem more ,,

and btw you can change that old autoequipments to a new smart one to

i got crash when i press start and there is my dumps error can u check it ?and help me if u can ?! :)

[Only registered and activated users can see links. Click Here To Register...]

or u can tell me producers tables name of auto equipment and i`ll check it by myself ? !

07/21/2015 04:26 Eslam Galull#6

Mr Dev.Ahmed_Elnashary

Use Royal AutoEquipment >> Google Search Credits gose to RoyalBlade

07/22/2015 02:38 Dev.Ahmed_Elnashary#7

solved :D thnx guys