More information is needed. Table and Excel Schemas would be helpful. As would some sample data. See the links in my signature.

Yes it only applies to the join. The data is not changed.

If you did a begin transaction you need to do a commit. You can run DBCC OPENTRAN() to determine if you left the transaction uncommitted.

The best idea is to get RedGate SQLCompare or Apex SQL's product I think it is SQLDiff.

It sounds like you are trying to use anonymous access to the smtp server and you need to provide user name and password on the mail account you have setup.

First I would look at any SQL Server Agent jobs and make sure that they are not doing the deletes.

Then you have a couple of options for tracking...

You would need to drop the Foreign Keys then re-add them after you make the change.

I think you would have to have the Network admin setup the account and allow you to change the password so only you have it. This is a common...

I am just guessing, but I believe that MySQL and SQL Server backups are completely different formats so you can't restore one to the other. I could be wrong.

Could you post specific errors and some code? If you are using CTE's and the new statistical functions (Rank(), Row_Number(), etc...) and other new features the procedure creation will...

IF you are using SQL Server 2005 you do not need SQL Server to run as a local administrator. If you use the SQL Server Configuration Manager to set...

Lookup sp_start_job in BOL. That is the command you need to start a job in a SQL Script.

As I said in my previous post "you can then add it to the toolbox". You need to right-click on the toolbox and select Add Items. Then you...

Great, I hope it helped you understand triggers better.

Thanks Jeff. I could write something more detailed about INSTEAD OF triggers, but I've never actually used one in one of my databases. I use stored procedures to...