No you dont need IIS.

You need to ensure that the server can connect to the relay machine, you send to a valid email address and that mass mail worms are...

Speak to your mail admin person, they should be able to help.

But it looks like your trying to send a mail to an address which doesnt exist.

What version of SQL are you running, Standard or Enterprise? If Standard then it will be multiple copies, if Enterprise you can use data driven subscriptions

Then you must be using an earlier full backup and not the current one from the latest 10:30 backup.

Check through the backupset table and correlate which log file it is...

What type of mail server do you use for SMTP? If its Exchange and you use the mail relay functionaity you need to ensure that you allow the IP...

We do backups to local disk, then the backups are backed up via the SAN backup, they are also shipped to the virtual tape array via NetBackup and they are...

Grognak the Barbarian

Also can you post the deadlock graph?

Why are you using the Jump to URL option and not the Jump to Report option and using parameter pass through?

Report in a different solution, report on a different server?

Nothing more? Nothing above or below that line?

Yes that is correct, you have to meet certain pre-reqs first and ensure that you add in the nessesary hints etc.

This link will describe more

http://msdn.microsoft.com/en-us/library/ms191244%28v=sql.105%29.aspx

What does the SQL error log say?

Using INTO in a simple or bulk logged recovery model uses minimal logging, so depending on how much data your moving you shouldnt see that much of a transaction log...

The only way to bring the Execute Procedure screen back up is to right click the procedure and select the execute option.

Or as I have said above, you know what...

If you know what data you want to insert via the proc, just call the proc using the exec / execute clause

EXEC [IT].[Insert WorkRequest proc] @.... = '' ,...