Uripedes Pants (7/26/2011)

---

you also might want to add a step in there that transfers data from 'myTable' to 'TEMP_myTable' before dropping :w00t:

EDIT - I just noticed that this thread is...

There are three options that I've verified to work up through SQL2008, all each being variants of the sp_notify_operator SSP:

1) Add an operator to the group, like "DBA_Group" and in...

The answer to your question, Nazri, is that Enterprise Manager (2000) and SQL Server Management Studio (2005) actually go ahead and create temp tables with the desired column order (the...