hmmm... I just tried editing that post and it seems the website won't allow XML tags. I typed it out and edited the post but nothing shows.

I'll try it another...

Thanks Adi for the reply....

The issue is in this statement:

exec @hr = sp_OAMethod @object, 'AddAttachment',NULL, @Tmp

You can't provide a NULL value for that output parameter. You must provide a blank value...

I get this same error when trying to add an attachment to my CDO proc. I still receive the email and the attachment however it still throws this error.

If I...

Is this a production database?

There could be a number of things you need to address.

Do you have indexes on each table this query involves? Make sure they include the...

Sergiy,

Yes your correct about several points. I didn't write it for a multiple insert/update yet and I need to. The trigger also doesn't validate on the Eng_ItemDesc uniqueness which it...

I call that cursor proc from another proc "sFileCreate". This proc actually calls that cursor proc then takes the output and creates a txt file:

Create Proc sFileCreate

as

declare

@HR int,...

toniupstny,

Thanks for the code. I actually used a trigger last week. Here is my code:

ALTER TRIGGER [dbo].[trg_FeeTypeAbrvCheck] ON [dbo].[t_XREF]

FOR UPDATE,INSERT

as

DECLARE @Ref_Type varchar(20),

@Eng_Code varchar(11),

@Eng_ItemDesc varchar (50),

@CheckBit tinyint,

@ID int,

SET NOCOUNT ON

IF UPDATE(Eng_Code)

BEGIN

select...

Sergiy and Jeff,

Thanks for the vote of reassurance!! LOL! Seeing how SQL is not a text editor what would be your recommendation for situations like these?

This is a case of...

I set the options in Managment Studio to "off". So I don't have to use the SET Command within the Procs. It didn't recompile so I guess that works.

But will it force a recompile doing it that way?

or does the recompile happen cause the setting is changing from the default setting?

Thanks for the reply. I guess I'm going to have to isnull a whole lot of stuff! ughh!

Okay now I'm really confused...

I set the DBOptions in a Test DB to Concat Null Yields Null to True and False and with both settings I still get a...

Okay I found were you can set your default options in the Database Property:

Syntax

DATABASEPROPERTY( database , property )

IsNullConcat Null concatenation operand yields NULL. 1 = TRUE

0 = FALSE

NULL =...

Thanks for the reply. I used a trigger to handle this issue but it would have been cool if I could do it with a constraint.

I guess that's a...