We have very good experience using views. Gathering data together in a way over many tables for eg. processing data.

If your view is becoming slow consider using indexed views....

In my opinion search should also be within the forum. Now google search is implemented on SQLSERVERCentral.com and searches within the complete website including articles and the forum.

I would appreciate...

Perhaps your solution is in making triggers on the tables that are affected.

Especially when table and column names differ in the two configurations.

Thank you Dustin for explaining!

Database mail is working now using msdb.dbo.sp_send_dbmail. Now it still leaves me one problem, sending notification emails within jobs, SSIS packages and Maintenance plans.

In the...

@Dustin, no i can't find a reason unfortunaly

What i have found out is that this procedure is not working:

EXEC master.dbo.xp_sendmail

@recipients=N'[my emailaddress]',

...