I don't know any tools, but if you are in a hurry, you can always restore the db on a test server, then copy all needed objects to production!

Use EM / SSIS or drop the objects then rebuild. (you may use the EM to see what script must created, then copy paste so that you can run it...

One less gotcha to learn .

Why not use the float datatype?

While float is not a precise datatype, it sure beats varchar for this case.  Also you can check out the decimal option, maybe that will...

Yes you can both be right.  The value will be set to the last row updated, however in a few rare cases the, update may be done in something that...

Convert the date to a varchar then the isnull will do what you want it to.  Or you can always let the application handle the nulls when displaying the data.

You are actually both right.

But just to make sure of this behavior, you can use an index hint in the query.  This pretty much guarantees the results.

Have you tried seting this login up with a domain account that has access to both servers?

This is just a guess, make sure you test it before implementation :

UPDATE T1 SET T1.ItemLength = T2.ItemLength FROM dbo.Table1 T1 INNER JOIN dbo.Table2 T2 ON T1.ItemCode = T2.ItemCode

Search for cast, or convert in the help files.  You will find the correct function to do the conversion.  I would give it to you now but I forgot the...

What is the current max utilized row size in your table?

Any way you can reduce that?

This question is posted twice.  Continue the thread at this adress :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=367470

One would be to reduce the row size, but I guess you already knew that!

It's still not at all clear to me what you are trying to do!  Can you post in details what problem you are trying to solve?

There are a few ways I can think of to return more than 8000 characters to the application, but what exactly do you need to do?