Sigh. What exactly are you trying to do when you get this message? The message itself is pretty clear about the problem. At leaast one value of...

Form this:

http://msdn.microsoft.com/en-us/library/ms178804.aspx

it doesn't appear there is a recognized designation for NULL. How is the flat file being produced? Can you run it through some other tool (like sed)...

I think you may have a problem with both the 'select' and update statements. With no 'where' clause, the selects will return the whole table, and the variables will...

We don't normally set it as a standard practice, but we watch the paging and set it if needed.

There isn't any way to use a newer version backup to restore to an older version of SQL Server.

You'll have to script out all the objects and copy the data....

Take a look at REPLACE.

REPLACE (string_expression,string_pattern,string_replacement)

select replace(phone_num, '-','')

As long as we're all just guessing...

Maybe the old developer zipped up his SQL to deliver to you. You might try to unzip the file and see what happens.

If...

For the BBQ fans at PASS in Seattle, the Warthog in Fife, and the Ark in Northeast Tacoma (both about 35 minutes south) are worth a trip.

What happens if you just enter:

bcp -v

Lutz's solution will be far faster than the cursor and will ensure the rows are returned correctly. The SQL Server isn't required to give the rows back to you...

Are you trying to record the text of the dml that did the update? If the updates all come through procs, you might look at this:

http://www.sqlservercentral.com/articles/SQL+Server+2005+-+TSQL/2765/

Other than that, I...

The way you have this set up, you can't ever be guaranteed to get the output you want. Based on the output, my assumption is that you want the...

Without some additional information, I'd just be guessing. Could you post both the queries and provide a little context about when and how they are executed.

How big are your databases? I think the express edition (free) will now support up to 10 gig.

D'oh. Yeah, what Gail said.