Thanks for the input.

Oh, yes, I did mean an empty string. The data is in fact that, and not already a NULL value.

>>>UPDATE sometable SET somecol = NULL WHERE...

What gave you that idea?

Where would I look to determine if the user has access rights to view all procs?

TIA

It doesn't seem to - there is no reference to another server.

>> Does the account that you are using have access to see all the procs? <<

Do you mean...

Thanks again for putting up with my denseness.

In the Client Network Utility, there is one entry for Server Alias Configuration - it has the name of my SQL Server, and...

>> And have you confirmed that there are no alias entries in the client network utility that would cause you to connect to the wrong server by mistake? ...

The ones I'm trying to copy are all user procs.

It's very strange, like it's drawing from other source of objects entirely.

Some of the successfully transfered objects are similiarly-named...

Thank you for the response.

I think what happened was during DTS I must've inadvertantly checked 'Copy Logins'...

Aw, heck, I posted this into the wrong category!!

Thanks all for the input.

I found the following article, which applies to this situation where there are both Integer and Non-Integer values in this VARCHAR column:

http://support.microsoft.com/kb/271566

Despite my desire...

<<>>

VALUE1 contains both Integer and Non-Integer data, so changing the datatype isn't possible.

>> Is the data exactly the same in both ? Did the query I posted above (checking IsNumeric() ) return 2 rows in *both* databases ? <> ...

Thanks again,

Is there any way to prevent the server from trying to convert the column to the datatype of my hard-coded value?

Also, why would one db do this and not...

Thanks for the input PW,

VALUE1 is a datatype of varchar, and I have both Integer and Non-Integer data in there.

When I ran that query, it gave me a 0 and...

Hi,

OK I figured this out by using the UNION operator.

Thanks again!