Ashfield this is exactly how I've tested everything. Values do come from linked server, and when I hard code the value trigger seem to update it just fine. I even went as far as changing the trigger to update from the local table (LOCAL SQL Table) and it works. The only issue I am having is when update happens from a linked server.

I am sorry, when Insert happens trigger does not seem to update the line. This trigger has other parts to it which seem to work just fine.

Hi, I am trying to add a trigger on insert event on a table in SQL_Express. ALTER trigger [dbo].[TR_Insert_New_Pair] on [dbo].[Vendors] FOR INSERT AS DECLARE @ACCPACID varchar(12), @VNAME varchar(60) SELECT @ACCPACID = (SELECT ACCPACVENDORID from inserted), @VNAME = ( SELECT VENDNAME FROM [ONT-ACCOUNTING].EXTDAT.DBO.APVEN --[ont-dell] is a linked server WHERE LTRIM(RTRIM(VENDORID)) = LTRIM(RTRIM(@ACCPACID)) ) UPDATE dbo.Vendors SET VENDNAME = @VNAME WHERE LTRIM(RTRIM(ACCPACVENDORID)) = ltrim(rtrim(@ACCPACID)) --This part works great (I've tested) SELECT VENDNAME FROM [ONT-ACCOUNTING].EXTDAT.DBO.APVEN --[ont-dell] is a linked server WHERE LTRIM(RTRIM(VENDORID)) = LTRIM(RTRIM(@ACCPACID)) Is there something I am not seeing ???? Thanks Kirill

select * from yourtablename where DateDiff(year, myDate, getdate()) >= 3

Hi, I am trying to help my IT department by developing a simple vb.net app where I am going through EventLog on XP and Vista Boxes and uploading all EventEntries to a db hosted on MSSQL-Express. The executable sits that sits on a client PC and is compiled as a console app that gets fired up through scheduled task. My app attempts to insert new records for every record found in EventLog on each PC on the network to db at around noon (noon is the time when scheduled task fires up my app.). I have about 50PCs on the network and I use Procedure to insert new records. My question is, how many simultaneous connections MSSQL-EXPRESS can handle and what happens when I attempt to insert into the same table from more than 1 client. What would you recommend if I needed to increase number of workstations that upload to DB. Appretiate your help and advise.