Yes, I see that.  The Package is set to be  executed against one of the user databases on the local instance.  I CAN run the code from the stored procedure...

This step is calling a stored_procedure (see code above)  I AM able to run the code from the stored procedure from query analyzer but when it tries to call the...

This is the stored procedure:   I understand that I can run this code from query analyzer and perhaps see where it's failing..  but I'm not sure which DB to run...

Amen to that!!!

check out sp_help_revlogin. I've used it on 7.0 instances to move userids (and passwords) between instances.

Another question related to this topic.... How does does MS SQL Server build 7.00.623 (MSDE) get installed? Is it similar to MSDE 2000 in that it gets installed...

hmmmmm maybe we should add those to the list!

http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=10&tabid=13

This is all SO helpfull. thank you very much

Thanks for all the help and ideas. We have used the MS tools for scanning but I am going to look at the SQL Retina Scanner also. I...