Ninja,

You wrote:

Select IDCol FROM dbo.MyTable WHERE ISNULL(Col1, '') <> ISNULL(CONVERT(VARCHAR(newsize)), '')

What I am not following is the condition in the WHERE clause:

ISNULL(Col1, '') <> ISNULL(CONVERT(VARCHAR(newsize)), '')

What are you accomplishing...

"Take another backup and go take a break..."  I love it!    Maybe I'll make the change and then go on a vacation...

You are correct, Wanderer, we did not attach any of the system databases, when we attached our databases.

I've noticed that none of our maintenance plans came over as well.  Are...

So, MG, is it the case that being able to view the DTS packages is not on by default?  I spend some time on Microsoft's SQL site to see if...

I've thought about this question, but more from the opposite end.  Who would I not want.  Unfortunately, I have more experience with that.

For example, two years ago we were very...

alzdba, the sp_change_users_login system stored procedure did the trick, thank you very much!!!

No, the DBA's uninstalled SQL 2000.

So, what do I do now?  Is the only way to fix this problem is by using SQL...

Thank you, Stax68 and Claudia.  I appreciate your help. 

stax68,

I've looked at the message you referenced, but have a question.  Gregory Johnson, who posted the message, used a column called colX.  What's that?  I don't see it anywhere in...

"...where the pay is better but the programming is a lot less fun."  Boy, I hear you, rbrownson.  I love what I do, but I really loved it back then,...

The first program I can remember writing, was when I was working at the National Radio Astronomy Observatory’s Very Large Array, near Socorro, New...