AttributeValue

It's set to VARCHAR(8000)

I don't understand how it can be truncating if I'm SELECT(ing) from it.

Thank you all for the replies! Great resources on this site!

Thanks again. I am going to get started today. I'll let you know how I make out. Thanks for the direction.

Ever play around with the file watcher Matt?

Thank you sir!

Thanks Nicholas! Can you post your code?

That's what I was afraid of. Thank you!

Yep Wayne. That is what I always use when moving users, especially local ones! Thanks!

Server team is dragging their feet regarding the issue. I am ensuring CYA.

As I mentioned, I never sent it. Thought twice about it and wasn't a good idea. My apologies.

Yes. daily backup of system db's. Ever since we cut over from Hitachi SAN to EMC, our cluster blue screened and needed to be restored from a previous...

Gila,

Nope, practice test from MS book. Actually, I didn't send it to anyone anyway.

Yes. Thank you.

EXEC sp_MSforeachdb 'USE ? IF EXISTS

(SELECT 1 FROM sysusers WHERE name = ''MYDomain\myGroup'') DROP USER [MYDomain\myGroup]'

Again, Thanks for your help!

PERFECT!! Got another one if you're not too busy.

Do you have a script to loop through the users and logins I want to drop and recreate.