Ok I did a test and had no issues. Do you still get the error with the CREATE TRIGGER I suggested or is it something else wrong. What is happening...

What versions of SQL are you running on the box and have you installed alternate client tools at any point. Also, is this a domain account or local account and...

Oops I remember now, this is how we do it.

1) Create an Integer variable named varFlCtrl with an initial value of 0.

2) In you VBScript change the If statement that...

Try this...

CREATE TRIGGER [RecStat] ON dbo.tblMobilisationTransaction

FOR INSERT

AS

UPDATE

 m

SET

 RecordStatus = 'R'

FROM

 dbo.tblMobilisationTransaction m

INNER JOIN

 inserted i

ON

 m.ServiceNumber = i.ServiceNumber

WHERE

 m.MobID != i.MOBID

Also, what would you want to happen if m.MobID were...

I do find that table variables perform excellent but my datasets tend to be large so I still have to use temp tables so they get built in TempDB and...

Can you post you SP code so we can get a better idea of what you are doing. Also if your Proc name begins "sp_" you will get a CacheMiss...

SOrry but your error message isn't showing up here. Can you post the text?

Linked servers use the driver for the DB type you are connecting to and the funationality does not change for them. You also cannot write in most cases schema DDL...

Are all peices within the same scope. Same SP or in different ones, or maybe are you using dymanic SQL within you SP where the ones for the tempDB are...

Your example can there be more L and Rs or is this table fixed in size and options?

This is what I recall from SQL Server Performance.com

Don't run SQL Server on the same physical server that you are running Terminal Services, or Citrix software. Both Terminal Services and...

Do I smell a new app in the works sir?

I have looked at a few tools for this and still think they are all too high but if your market...

Check this out (plug for me yes). http://www.sqlservercentral.com/columnists/jtravis/sp_performance.asp

It is not an error but is generated as a warning to notify you this has taken place in case someone did without your knowledge you would know it happened...

Well I had a nice long helpfully post but it got eaten by the post button without showing up. I will try to rewrite it later but needless to say...