I was thinking...

You hit the nail on the head. I ended up taking the full backup of the live DB (that occurred last night), restoring it to the report server DB, then...

Thanks everyone! What everyone is describing is exactly what is happening...with the space followed by more text error. I appreciate everyone's input on this...it was very educational for me!

By "lost" I mean...the code is out there running, and we have versions of the source code in multiple locations. These multiple locations don't appear to be the version that...

Yes, Say Hey Kid, it's very similar to what you posted. I agree with a previous post...the real issue is in the VB code. However, I wanted to determine if...

Yes that helps...but I'm trying to resolve this without touching the VB code.

In your example, what would happen if you used double quotes?

It's just a string variable in VB. There is no " or ' choice. It works fine when you just pass in "ABC", but when a space is introduced...that's when...

But, whether it's being executed from VB or another SP, it shouldn't make any difference to how the current SP should be written...should it?

Actually, it's being called from VB and a string variable being passed in is holding the value "ABC DEF GHI".

Is there any "homemade" type solution that can be done in 2005?

Ah ha...that would be the issue...

Version:

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on...

I just cut-n-pasted from above:

DECLARE @VARBINARY VARBINARY (16)

SET @VARBINARY = CONVERT(VARBINARY (16),'0x0000000000018662',1)

SELECT @VARBINARY;

go

DECLARE @VARBINARY VARBINARY (16)

SET @VARBINARY = CONVERT(VARBINARY (16),'0x0000000000018662',0)

SELECT @VARBINARY;

go

I get:

0x30783030303030303030303030313836

0x30783030303030303030303030313836

It's almost like the "1" and "0" style options are not recognized?? Any ideas?

I'm using 2008R2. Is there some setting I'm missing??