Your SELECT statement looks good to me.  It should return the results that you've described.  If it only returns 2 rows as you've said, you can always verify this to...

I don't think that I am 100% clear on what you are after here, but here's what I have so-far.  The below table defs include the data from your post...

Max Server Memory is an instace level setting.  You could accomplish what you want by installing a second instance of SQL Server.  Run the production database on one instance and...

What Sergiy has given you will work for the same table.  Just replace the work Table in the query (for both T1 and T2) with the same table name.  This...

Although it is not explicitly stated in BOL, I don't think you can change the owner to a Windows group. 

What do you mean by 'it doesn't work'?  You say that you've tried to map the Windows group to DBO, what did you do to attempt the setup?

You don't have to account for it, the JOIN takes care of that.  Since you are joining on MF_ID = (list of ID's) the only way you would have a...

You can do this all in one stored procedure without having to do the first select.  Use a JOIN with a derived table so you don't have to do a...

That's great as I was stumped.  Anyway, I just wanted to point out an additional method for what you are doing.  Check out COALESCE in BOL.  It is easier to...

They are not checking the success/failure of sp_password before clearing out the password_change row.  Sp_password has a number of validations that it runs before it changes the password.  I would...

How did you migrate the data to your new box?  It sounds to me like the nText columns for HTML and Textual in your Custom table are not truely NULL. ...

You are using %s for your @spid1 which is an integer.  Try using @d instead.

raiserror  

   ('The  user with login :%S , running the program : %s has been blocked...

What exactly do you mean by 'can't restart the box'?  The /3GB switch should be added into the boot.ini file, not as a SQL Server startup parameter.  Adding it in...

Thanks for brightening my day Andrew.  The Chronicles of George is the funniest thing I've ever read, although I wish you had warned me that I would spend soo much...

Both Vladan and Tim have good suggeestions.  The reason I asked my first question is because I had a couple of solutions in mind.  One being the temp-table solution that...