Have you checked the documentation for xp_smtp_sendmail at sqldev.net? If you run the procedure in QUery Analyzer you should be able to see the error message in the Messages...

I believe in SQL Server you will need to do this in a trigger or in the process that does the insert. I'd lean toward having it in the...

SQL Server uses ownership chaining to handle these types of issues or as Gus has mentioned you can use EXECUTE AS. I have written a series of blog posts...

Have you tried running the backup to another physical location? Are your backups and data on the same physical drive?

When SSMS came out with 2005 I was very disappointed to see EM and QA combined. I'd still prefer to have my query application separate from the management application....

Unfortunately I agree with Grant here. It's never a good sign when all the...

You need to put teh expression in the color property of the textbox, not in the textbox.

Wow, can you still "freeze" IO in 2005 and later?

And this is why I use native SQL Backups until the DB's get too big so backups get too...

The only "gotcha" is that doing:

DECLARE @var VARCHAR(10)

SELECT

@var = NAME

FROM

sys.databases AS D;

SELECT @var;

works even thought there are multiple rows returned,...

Gift,

I'd be interested in knowing what you are doing in the stored procedures that make it so you can't use EXECUTE AS. I'm not saying you should, I'm just...

What events are you tracing using Profiler?

A trigger will have some impact on performance as triggers do work, consume resources, and extend transactions. The amount of impact depends on the work being done in the...

Sorry. Looks like the only way you can modify jobs is to be sysadmin or own the job.

Elliott W (12/2/2009)

---

I am a little leary of putting the sprocs in different schema from the tables they use. My main reason is tied to not wanting to grant...

Ha ha, I just remembered that my signature contains the quote:

"Don't let the good be the enemy of the best."