Thanks for the help getting this script to work. It is not apparent immediately because you cannot see the extra spaces(blocks). You have to paste the script into notepad and...

Thanks! This is great. Do you have a version that is compatible with SQL 2008?

I solved this, sorry for not posting my solution sooner. SQL Server Management Studio 2005 has some bugs. One of the issues is viewing securables. To fix this install SQL...

Sorry for taking so long to post back. Creating an alert in Windows Server 2008 requires you to first setup a windows scheduled task and also a performance counter. In...

I found a solution. I thought I would post it here since this has taken me a few weeks off and on to fix.

In Windows Server 2008 you must first...

Straight answer: whoever is paying your sms bill.

You can use this system sproc to find the details of a stored procedure

use msdb

sp_helptext 'sp_send_DBMail'

You cannot write a stored procedure with a period in it like that. A period...

I found a way to do this. Create a custom error that executes each job you want the user to use.

Then create a storedprocedure that raises the custom error and...

I have been reading security articles on SQL Server and it was recommended to remove buil-in\administrators for sql logins.

Thank you for the suggestions. The answer was I needed to add my sql service login account as a user in SQL with write access to the msdb database. After...

There is no error. The last thing in the database mail log is "activated" . When I manually run databasemail90.exe all of the queued mail messages are sent.

Thank you for the suggestions. I have tried all of those and I am still having the same issue.

Has there been an answer to this? I am having this same issue.

Roy Ernest (3/11/2009)

---

climbingbum (3/11/2009)

---

In case of a restore the answer I have been given is to perform a backup if the server is accessible. If the server is in a...

Thank you that is exactly what I needed to hear 🙂