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.
| 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 TextSELECT so.name, sc.text FROM syscomments scINNER JOIN sysobjects soON sc.id = so.idWHERE 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_nDoes 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 columnMadhivananFailing to plan is Planning to fail |
 |
|
|
ranjeetsingh_6
Posting Yak Master
125 Posts |
Posted - 2006-07-14 : 02:12:49
|
| Hi Thanks to you my problem have solved by you.Ranjeet Kumar Singh |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-07-14 : 03:27:48
|
| Also make use of sp_helptext 'ProcedureName'MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|