Doesn't work for me either ........ Looks like a bug in sp_who2. 

Your post just links to this same thread.

If you use DTS to move data, you can move one large table, but specify batch size so that SQL will break into batches for you. Then you don't need...

We bought xp_crypt to encrypt our Credit Card numbers in SQL tables. Perhaps that would work for you.

I have a farm, but I'm smart enough (barely) not to bet anything on it.

Can you use security to limit the users that have select permissions.  IS it just a few tables you're concerned about ?

Table Properties in Ent Mgr is not reliable.  You should use "select count(*) from table" to get accurate results.

Not quite sure what you mean by " ... looking through a backup file ... "

You're reading the .BAK file somehow ?

Depending on your recovery requirements, you could set your database to "Simple Recovery" temporarily while you run some of your conversions, then set it back to "Full Recovery".  Or you...

Do you want to copy the databases, or copy backups of the databases ?  You could ZIP the backup, or detach the db, then zip that. ?

Edit:  Yeah, I forgot...

The Notification Services Admin forum & SQL Admin forum often get mixed up.  It's a little confusing the way it's laid out.

We recently bought Idera's Diagnostic Manager, and it has...

DECLARE @a VARCHAR

SET @a = ','

SELECT

LEN(REPLACE(FIELDA,' ','')) - LEN(REPLACE(REPLACE(FIELDA,' ',''),@a,'')), FIELDA,*

from TABLEA

You can use "collate" in the where clause to join fields with dis-similar collations.

How about:

INSERT INTO @Reports (userid, orglevel, managerid)

  SELECT userID, @intOrgLevel, managerid 

  FROM CurrentContract WITH (NOLOCK)

--Problem...

Would this be helpful ?   It describes how I look at jobs & how long they run>

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=208602#bm208736

P.S.   Post in the SQL forum next time for better viewership

Hey Remi  ....  using a separate post for "HTH" is cheating !!!     🙂    That shouldn't count towards your total !