The message is pretty clear. The login is the owner of one or more databases. You need to change the owner of those databases to be able to drop the...

Did you update all statistics with full scan after the upgrade?

Why?

SQL instances don't need to be rebooted daily. Hell, I know of instances that...

😀 :hehe:

True, yes, it's a good starting point, better than the total wait stats since sometime...

It's not. Only directly in the trigger.

For a change I'm going to disagree with Grant. Daily is...

The only 'normal' which exists is normal for your server. Different databases, hardware and workloads will have different 'normal' wait times. It's also impossible to tell anything about yours, because...

It might be a recommendation for consistency, since functions do require the BEGIN ... END

Union all is usually the preferred way, if that's causing problems you could try inserting each resultset into a table variable and querying the table variable.

To say anything useful about...

Please enable the trigger and run a single-row insert into cat_transactions from Management Studio and post the exact, complete content of the messages pane afterwards.

It shouldn't say one row affected. It should have more messages than that from the trigger's execution. That was with...

The only way that could happen is if there's a rollback occurring.

If you run an insert into cat_transaction from a management studio query window? What exactly do you see in...

From an application? When you connect to Management Studio? Something else?

http://www.sqlservercentral.com/articles/Indexing/68636/ (also see the other two in the series)

http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/

What data type is pd_desp?

To be honest, unless the description tends to be thousands of characters long or a LOB data type, it's probably fine as an include. You definitely...