What is the result of executing the following statement?

exec sp_configure 'Database Mail XPs'

Andrew's answer is excellent. Two ther potential ways of dealing with this other than updating the statistics is:

1. Use hash join hint - not a good idea for the procedure...

I have several templates, and I also have code for capturing server side trace data. I was not aware that we could post file attachments though because the trace templates...

select * from msdb.sys.objects

sys is the schema, not dbo.

Regards,

Toby

Reading your sentence again I guess you are getting the error when you attempt to send a test mail through management studio - is this correct?

There seems to be two distinct issues and I am wondering which one you need to address. One issue is that the SQL instance actively refused a connection, and the...

Data masking is a general term. More than one way exists to accomplish this, but if you are just concerned about how to store the data in the database in...

I have been unable to make the insert succeed on SQL2k5 with any combination of changes in database settings. I have also failed to find reference to this in SQL2k...

This is some seriously odd behavior indeed. I am looking into it further.

Regards,

Toby

Oh, I think I see the problem. If you need to use it in a select statement then you probably want to create a table value function for it instead...

Are you using the Execute keyword before the procedure as in:

Execute dbo.sp_GetBadge ?

The stats seem good on your server other than procedure cache hit ratio - but that is to be expected with dynamic SQL. It also looks like there is no...

If the account has lock pages in memory then the trimming probably isn't applicable. This can happen when the O/S decides to reclaim memory from SQL Server. The fact that...

Look at the SQL server log. Is SQL Server getting its memory trimmed during this period of time? Also, If you are running a 64 bit machine turn off AWE....

Why would a process be limited to 2GB of memory on a 64 bit machine? I would look at what processes are consuming the memory. You can do this with...