I already have that. The requirement is to use the Windows Security event log.

I found the issue using the checkDB function with data purity which is what caused me to post. What I could not do was identify the rows themselves...

What did you remove form MSDB and/or master? I am having the same issue as you.

Do you have a good way to detect any of these orphans? I am also having the same issue and cannot resolve it.

I have used many types of analogies. A phone book wasnt one of them. I am not looking to re-hash what I have done. I am looking...

You need to add the alias identifier at the end. The select statement makes table 'x'.

SELECT

'REVOKE ' + convert(varchar(50),x.[Action])

+ ' on ' ...

Good Stuff. I will find those articles! I wasnt drinking at the time. LOL

you and me both. I comment the hell out of my stuff. I dont think the couple lines here and there are an issue. I think it...

As I remember the article, that is the root of the problem. Due to the large block, the compiler/execution plan cant do it's thing properly. so pretty much...

Parameter sniffing is a separate issue that I had them deal with. As for the coment block, there is somthing regarding the amount of lines and size of the...

DUH! Why is it the simple answers go right past us. You are absolutely correct and it works like a champ. Thank you for the smack in...

I am sticking the code being used now here:

CREATE PROCEDURE [dbo].[sp_send_cdosysmail]

@From varchar(100) ,

@To varchar(100) ,

@Subject varchar(100)=" ",

@Body varchar(4000) =" ",

@attachment nvarchar(100)= " ",

@bodytype varchar(10)=" "

/*********************************************************************

This stored procedure takes the parameters...

CREATE PROCEDURE [dbo].[sp_send_cdosysmail]

@From varchar(100) ,

@To varchar(100) ,

@Subject varchar(100)=" ",

@Body varchar(4000) =" ",

@attachment nvarchar(100)= " ",

@bodytype varchar(10)=" "

/*********************************************************************

This stored procedure takes the parameters and sends an e-mail.

All the mail configurations are...

Did anyone ever come across this error? I am now having this issue with no good results on a resolution. It has happened twice.

HAs anyone answered here?