On SQL Server 2005 you could query the default trace which audits object altered, created, deleted with a query like this:

SELECT

TE.[name] AS event_name,

...

Right and what Ramesh is saying, and I am agreeing with, is that it appears that there was an error in the SP2 install on the server where sp_send_dbmail is...

Please read the articles linked in my signature for how to post in order to get better answers. I will attempt to answer your question, but without the information...

Ramesh (2/18/2009)

---

...I was actually correcting my statement in a new reply but you beat me on it:D.

Now...

Is it the same on both servers? That is the base SP2 install.

Ramesh (2/18/2009)

---

What version your SQL Server 2005 is? Is it 32 or 64 bit? Database Mail is only supported on 32 bit versions of EE, DE, WE & SE...

What about CU's?

Duplicate post. Please post answers here: http://www.sqlservercentral.com/Forums/Topic659347-146-1.aspx

Are both the servers at the same patch/service pack level?

You can use transactional replication and there is a way to NOT replicate deletes. Check out this blog post about how: http://kendalvandyke.blogspot.com/2008/12/hey-i-said-not-to-replicate-delete.html

I have to ask, why are the database names different? Is your dev environment on the same box as your production environment?

Ramesh (2/18/2009)

---

By default, users on Windows Vista that are members of the Windows Administrators group are not automatically granted permission to connect to SQL Server, and they are not automatically...

I believe that you need to set the Report Server Virtual Directory to allow anonymous connections. But I could be wrong.

Can you post the code you are using to bind the report to the report viewer? Are you sure that you spelled the path correctly (no typos)?

You would need to go through each sp and add the WITH ENCRYPTION option to the script. If you always want to create procedures with encryption you could create...