Yes you would greatly benefit by moving the 'old' database over to your new server and modifying your views accordingly.

Well stated summation of what it takes to be successful in life.

Get the column names from sys.columns -- if it is a table it will have a row in sys.objects and one row for each column in sys.columns. Here's a...

insert the pivot into a temp table first, then select from that with you roll-up totals.

A global temp table IS a real table. The only thing different about a table that starts with # or ## is that it will be dropped when the...

Report it to Microsoft, sounds like a bug to me. Schedule a graceful server reboot.

You...

Sounds to me like you have no good indexes on the mail queue (table) and so the query to find new records and the query to update the ones you...

As it stands there appears to be no definitive way to associate a row from table1 to table two. However, assuming you want it to be the order that they...

The native encryption methods in SQL server use a "randomizer" seed to make it difficult to infer values from a large set of values. That is why you are seeing...

Exactly. You could even use a stripped down...

If you think about, it has to work that way or impersonation would then have a huge security hole in it.

You should consider using a key server scenario (tier) to...

And... the OP said this trigger is on 35 other tables. :w00t:

Yeah, there is something sort-of fishy about a design that would incorporate that kind of [il]logic in a trigger. But without seeing more information about this entire design there is...

Besides wondering why this is being done in a trigger, I am wondering why this trigger is written in such a way as to assume that every insert is...