How about putting the user in the db_denydatareader Database security Role?

What's your Max Server Memory setting in SQL Server? Any sign that the server ran out of available RAM?

Interesting! When tinkering with data, I've often forgotten to to run COMMIT TRAN until the last change, then just ran COMMIT TRAN repeatedly until "The COMMIT TRANSACTION request has...

The answer is yes. If the code in the inner BEGIN/COMMIT TRAN runs without a SQL error, I was able to undo the changes with the outer ROLLBACK TRAN....

I'd guess you have at least one record with an ID that is a negative number, and has a value in DATE that cannot be converted to a DATETIME value.

Try

SELECT...

Since the procedure uses multiple update statements depending on the parameters entered, I have BEGIN TRAN inside the procudure with a COMMIT TRAN at the end of the TRY block...

Correct. Users need to be able to optionally set a date other than the current date. Sean's suggestion to default to null and then use ISNULL() set it...

You can pass the recipient list as a variable as in

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'YourProfileName',

@recipients = @emaillist,

...

I've seen this happen with a funky installation of Management Studio. Try it from another computer.

Have you confirmed your Standard Edition is 2008 R2 and not 2008? We ran into an issue based on that confusion yesterday.

Starting with 2008 R2, Standard Edition...

Do a set of system file backups (bak), then the next time you can stop the SQL Service, make copies of the MDF & LDF files.

I wouldn't trust a master...

I am assuming that the SELECT TOP 1 Record_ID ..... ORDER BY MODIFYDATE DESC is going to return the record that was just modified. Is it...

If the object already exists the Agent Job will be logged as errorred rather than success.

In this situation, the procedure is simply not going to be...

The link is on page xxvii:

http://tsql.solidq.com/books/tk70461/

This would break any code that references the instance name, any linked servers, ODBC connections or connection strings in connecting applications out there. There a lots of gotchas so...