Does Trigger Size is limited in sql server 2000

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Does Trigger Size is limited in sql server 2000

Author

Topic

ranjeetsingh_6
Posting Yak Master

125 Posts

Posted - 2006-07-14 : 01:18:06

Hi
I created a trigger on a Table in SQL Server 2000 for insert purpose which is below:-

CREATE TRIGGER tr_updateStockQtyBy_GRI ON tbltGRIchLink FOR insert AS update tblGrQtyStock set intgr_StockAtBranch=intgr_StockAtBranch+(select i.intgri_ShortexcessQty FROM inserted i )where (select i.txtgr_no FROM inserted i) =tblGrQtyStock.txtgr_no and tblGrQtyStock.txtbr_Branch=(select txtgri_Branch from tbltgri where txtgri_no=(select i.txtgri_no from inserted i))

but when i see Text of this trigger i got incomplete text of this trigger WHY? I Was Execute this query To see Trigger Text

SELECT so.name, sc.text FROM syscomments sc
INNER JOIN sysobjects so
ON sc.id = so.id
WHERE so.name = 'tr_updateStockQtyBy_GRI'

And I got this Incomplete Trigger:-

CREATE TRIGGER tr_updateStockQtyBy_GRI ON tbltGRIchLink FOR insert AS update tblGrQtyStock set intgr_StockAtBranch=intgr_StockAtBranch+(select i.intgri_ShortexcessQty FROM inserted i ) where (select i.txtgr_no FROM inserted i) =tblGrQtyStock.txtgr_n

Does Trigger Size is limited in SQL server 2000 if yes then what is maximum size and how i will increase size of Trigger.

Ranjeet Kumar Singh

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-07-14 : 01:44:18

In QA goto Tools->Options->Results then increase the value of Maximum characters per column

Madhivanan

Failing to plan is Planning to fail