The behaviour you watch follows ANSI standard.

According to it ORDER BY looks for a column(s) with name(s) specified in outgoing resultset. If it can find specified column it sorts by...

I don't have a chance to run proper tests now, but I would not say this if one of my colleagues would not destroy production database by an UPDATE statement...

You did not answer the question:

Can you provide an example of your INSERT statement?

Insert into OEORDH?

For remote calls ALWAYS use quoted identifiers.

And it must be double quotes, not square brackets. Because of the drivers implementation.

select * from "mysql"."database"."dbo"."cust702"

And don't overuse remote calls.

They are extremely...

You have at least 6 DB's:

master, tempdb, model, msdb, pubs, probably Northwind, and you "test DB" is 6th...

Greg Snidow (11/9/2007)

---

This should do what you want

UPDATE tableA

...

[Code]

SET @dbname = 'sysobjects] SELECT ''Hello, you are hijacked'' sp_password @old = NULL, @new ='whatever', @loginame = 'sa' --'

[/Code]

How simple is that?

Start from here:

Where have you got this piece of information stored?

Since the row are already inserted you need to update them.

have a look at this:

http://www.sqlservercentral.com/Forums/Topic417516-8-1.aspx

OK, now not...

Lowell (11/7/2007)

---

Thanks Theo; I really need to test that myself , as I clearly don't make enough triggers; I should have known that...i assumed that the tables would only be...

Can you provide an example of your INSERT statement?

Is it everything you've got in the trigger?

Jeff Moden (11/6/2007)

---

True enough... and nicely done. I was being a bit sarcastic because the OP didn't want to use a stored procedure... I went a bit overboard with...