It seems likely that linked servers do not support triggers (spit - I hate triggers) so I would do the following. Do some reading on linked server/triggers (you mey get a definitive answer here). Move the insert to Access out of the trigger and into the proc that inserts into your SQL table. You will miss any inserts that do not go through the proc but is will work. If you have data inserting from another source then track it down and nail it. Never underestimate the power of human stupidity RAH

Reverse Polish Notation[^] and something to make use of it[^]. Or even CodeDom[^].

javascript var obj = new ActiveXObject("Wscript.shell"); obj.Run(FileName);

Hi Thanx for your suggestion. It might have been able to work, but I forgot to say that this is on a SQL 2000 Server and unfortunately does not support XML!

Hi Here is my code. CREATE Trigger [trg_MovementsLog] ON [dbo].[GtrDetail] FOR INSERT AS INSERT INTO tblMovementsLog(GtrReference,Line,StockCode, QtyMoved, MovedBy,TransactionDate) SELECT inserted.GtrReference,inserted.Line, inserted.StockCode, inserted.GtrQuantity AS QtyMoved, SUBSTRING(LotTransactions.Narration,9,Len(LotTransactions.Narration)-8) AS MovedBy, inserted.TransactionDate FROM inserted INNER JOIN GtrLot ON inserted.GtrReference = GtrLot.GtrReference AND inserted.Line = GtrLot.Line INNER JOIN LotTransactions ON GtrLot.Lot = LotTransactions.LotJob AND inserted.GtrReference = LotTransactions.Reference AND inserted.StockCode = LotTransactions.StockCode WHERE (inserted.TargetWarehouse = 'HS') AND (NOT (inserted.TransferComplete = 'Y')) AND (LotTransactions.Narration LIKE 'JOB_TRF_%') I know however that my code does work. The trigger use to work fine until they re-installed the server. Also it runs if I manually insert a record into the GtrDetail table. It just does not run when it's basically inserted via a script (Well, so it seems). Thanx for your assistance. Elizma modified on Thursday, July 2, 2009 2:55 AM

Hi Elizma, I have the same problem with IIS 7 on Vista. After I modified my PNG files IIS did not refresh them, so I could see only the old version of them. As a workaround I switched to VS 2008's Development Server (Project properties / Web / Servers / Use Visual Studio Development Server) as you did. My only problem with this, that sometimes the Dev. Server handles the cookies incorrectly, I so need to switch back and forth between IIS and VS Dev. Server :-D Interestingly I had no problems on our production server. I hope we'll get a proper fix soon... Andras

You can shrink the logfile on demand. There's help on how to do that from the Management Studio here[^], or if you want to do this from SQL, look here[^]. That will only help until the file fills up again, or you'll have to hunt down the reason why the logfile is filling up. The documentation on the transaction log can be found here[^]. Good luck :) I are troll :)

Try the ASP.NET forum, you will get better responses. Check out the CodeProject forum Guidelines[^]

:-D :thumbsup:

;) ;) Cheers!! Brij

Have a look at UPDATE[^] statement's WRITE method if you have varbinary column. Otherwise see WRITETEXT[^]. The need to optimize rises from a bad design. My articles[^]

Elizma wrote: I am almost 9 months pregnant! If that is true I apologize for my last post. I certainly don't want to cause you any stress. Elizma wrote: I asked a stupid question Apparently your question was not stupid but just that you did not supply enough information for us to determine what the problem was. I am glad you resolved the problem. All the best to you and your baby. :rose: led mike

Hi There. Thank you so much for your reply. This was eventually the solution that I also came up with. What I've been told is that in SQL 2000 replication of Iserts and Updates alone cant be done, but it can be done in SQL 2005 by editing the Replication Log file and deleting the delete section. (Well, so I've been told). Unfortunately we user SQL 2000. Triggers will have to do. Thanx again for your reply. Kind Regards, Elizma

Check out http://itextsharp.sourceforge.net/[^] Vasudevan Deepak Kumar Personal Homepage Tech Gossips A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

Can you show a snippet of how you are streaming the file to the client?

when u r making a setup of your project u have to set the property i'm not sure what was that let u know in 24 hours.

Hi, Instead of giving update button in the each row of grid u can give a button for updation.In the click event of that button u have to check for the value which is changed in text box.Then u can use button.attribute.add("onclick","JS function") to bind with server these values.Hope this will help u Regrds Lijo