i believe the mutating issue is when you try to update from anything other than the old; or new:

you want to avoid that.

it's not clear what you are trying to...

Joe you'll most likely use a procedure like this, this is just a model, but you can see how the proc might use CROSS APPLY (or a left join? it's...

look at the ER diagram i think you posted. the Meters table doesn't have that column, so you cannot try to join it in your query like that;

the error here...

you are very, very sparse on the details.

is there more than one instance of SQL on the machine, and that is why you changed the port number?

why did you change...

if SQL browser is not running, are you explicitly adding the port to your connection? how are you connecting locally?

join criteria is critical in any sql to make any sense from multiple tables.

because you are using the old style joins, and never identify the join criteria, you are getting...

you'll need to insert the flat file into a staging table...the flat file doesn't contain a varbinary string, right?

so you stick it in a table of the right data type,...

whoops i didn't read your quesiton completely. ; i was assuming a non-clustered setup;, i thought we were talking single server/3 ip's / 3 instances.

my mistake i think.

I think you'll have to modify each instance to listen to one IP address; then change the port on that one IP address so that it's 1433.

no instance should listen...

is exactly the same as

SELECT * FROM TableABC bananas

In the above, the word after the table is just an alias.

This is...

i would consider looking at whatever query the current code returns, and build a view of THAT, and fix the code to pass parameters for the WHERE clause;

there's a lot...

SQL is very similar, and there's two ways:

select TABLE_NAME,COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME='POS_TRANSACTION'

--or

select OBJECT_NAME(object_id) As TableName, name As ColumnName from sys.columns where name ='POS_TRANSACTION'

a nolock on an update is ignored anyway, so there's no advantage to adding it anyway.

only SELECT statements will honor NOLOCK, and then you get the usual possibilities about doubled/repeated...

03sunil (3/28/2013)

We have similar kind of issue, We have 9 instances running on windows 2008 box. All are 2008 R2 instances. We have problem with only one instance.

We are not...

your trigger is on the table TEST, but the update command is looking at a different table;

shouldn't that be...