Is this a production database they are making changes in? If it is you should setup a dev system that they make changes in and then do not give...

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)?