Title should have read IsNull and not Is Null. However interesting effect as you found out.

Example.

declare @x varchar(5)

select isnull(@x,'1234567890')

From BOL

Arguments

check_expression

Is the expression to be checked for NULL. check_expression can...

Unforutnately I have not had the need to mess with Cold Fusion yet so I am in know way truely knowledgeable. I suggest trying the user forms at the macromedia...

Is that the complete message or is there a number associated with it?

Nothing like that I have seen. How are you referencing the local server with . or (local) or a named instance? Try using 127.0.0.1 as the server name and see...

What is the full code lines source code? How are you applying the variable to the string and submitting to sql?

If you were referring to me. Sorry, busy this week. The answer was nothing else whatsoever was occurring on this instance/server as it is my local machine and no accounts...

Yes, the index things is correct. You can see a noticable performance increase as long as the drive is on either a seprate controller or if the same controller but...

Sorry unless Progress has a connecto for replication to SQL I don't see a replication method. Might need to create a filed in the table for a date time value...

Might, I won't have a chance until Thuesday thou to do further testing. Anything speciifc as far as table sturucture you want me to test. I will try with a...

One thing is to run profiler from the server side to montior your statements. Server exceptions (could be another issue causing) and connection states.

That can be handled best by the computer properties, advanced tab, environment variables. You can set either users temp or servers.

Is this the entire message or is their more? Most likely as EM uses SQL DMO heavily the DMO there may be a corrupt file in the install. You might...

The only probem with using the table itself is you will have to grant permissions on the table itself. Unless you can cotnrol with Cross-Database Ownership Chaining option. I suggest...

As long as the user account has access to dbA and dbB and has execute rights on both then you can use one connection and call either by 3 part...

Try setting the whole row of conditions based on the consolidation of like items. For instance the above could be done like so (as long as I didn't misread something)

if...