Using braindumps is cheating and can get your...

The trigger has to go on the table that the insert is been done into. In this case, that'll be on Table_1 in DB1

The trigger just has to insert the...

Indeed. With an update, the inserted table contains the rows as they are after the insert and the deleted contains the rows as they were before.

Sorry, I misread your question...

Add the /Q switch to the del command. It puts delete into silent mode so it won't prompt.

Try removing the square bracket from the end of the URL

Thing is, without seeing the exec plan I can't give you more than vague...

Run it on the SQL 2000 server in the database that you are trying to upgrade.

The query will always return a result on SQL 2008, as that's one of the...

What does the query I posted return when run against the original SQL 2000 database?

Phil Auer (11/12/2008)

---

Thank you very much for the on-point answers.

1. Is removing the inactive entries on a full backup an option (which I would want to NOT select) in SQL...

Looks like a conversion problem. If I'm interpreting the error correctly, it's saying that it can't create one of the new system tables because an object with that name already...

That is valid, but the order by will not be honoured. Order bys are only honoured by the query processor if they are in the outermost select statement, i.e. the...

That would make the log grow, it...

Animal Magic (11/12/2008)

---

What is happening (and i should have clicked earlier) was one of the statements this app runs is an update with no where clause, every 3 seconds. ...

Animal Magic (11/12/2008)

---

I have a feeling this is what my problem was. the amended table has 6 indexes including the PK clustered index, so the alter table would have...

Yeah, it will. Inserted and deleted will have the same structure as the table the trigger's definied on, excluding some of the LOB columns (I forget which ones)

If there's no...