That is why the ROLES are for, you can assign all the permissions to the ROLE instead of assigning each and every user, and add the new user or changed...

Don't know abt dropping all the STATS, but you can definitely update the stats for all the tables with UPDATE STATS. (It drops and re-creates the STATS)

Here is the script...

Your procedure is very confusing.

Here is the send mail example with attachments

EXEC xp_sendmail @recipients = 'Email@email.com',

@query = 'Query you want to specify',

@subject = 'Subject you want',

@attach_results...

You can use either ODBC or Microsoft OLEDB provider for Oracle and specify the rest of the options. In the security TAB specify the login/Pwd for the connection. Don't forget...

Since the DBs are very small you can either use DTS or Backup/Restore and take care the users part.

Here is a good article on moving 7.0 to 2000

http://sqlteam.com/item.asp?ItemID=9066

Edited by...

Robert will this work with user DB also ? or just System DB only.

Here is a good Source code By Peter Schmitz

http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=592&lngWId=5

On one main subject is good. That way you know whats your level in that area.