Use aliases to keep your code readable.  The ambiguous column may (also) have come in your SELECT list, so make sure you alias all the columns in there as well.

Mike

You may wish to consider enabling it - more here.

John

Mike

Does the database already exist on the target server?  Do you have Instant File Initialization enabled?  It sounds as if it's spending 50 minutes creating and zeroing the...

You need to join to KeywordsColour on CarColour = KeywordNo, and to all the other lookup tables in a similar way.  Have a look at this if you're new...

Traces are deprecated - use Extended Events (XE) instead.  Set aside an afternoon to read all about them, then try to create an XE session to capture job activity.  Post...

As I suggested before, I don't think CXPACKET is the root cause.  What other wait types do you get for the same process?  Please run this while you're waiting (fruitlessly)...

Are there any synonyms in the database?

SELECT name, base_object_name
FROM sys.synonyms

John

At a guess, I'd say the application is converting the password to upper case, which wouldn't have mattered on SQL Server 2000 (depending on the server collation) but definitely does...

How many jobs does this affect?  How long do they run before you get the error?  What SQL runs to cause the error?  Does this happen intermittently, or every time...

Not getting what percentages?  To find the percentage of free space in a file, divide the free space by the file size and multiply by 100.

John

Probably the best way is to split it into individual rows using a splitter function, which will also give you the row number, then reconcatenate with a

Are you looking for four separate rows, or a single row with three line breaks in it?

John