Trigger Guide

[Dev.Ahmed_Elnashary]

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



pump !

[Aaron*]

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

[Eslam Galull]

as Leonius asks you to explain the problem more ,,

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

[witchymoo]

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:

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:


good luck

[Dev.Ahmed_Elnashary]

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 ?!



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

[Eslam Galull]

Mr Dev.Ahmed_Elnashary

Use Royal AutoEquipment >> Google Search Credits gose to RoyalBlade

[Dev.Ahmed_Elnashary]

solved thnx guys