Svetlana,

Thanks for the post! I tested it and it worked just fine! This is great learning for me as I can see how...

Steve! Sweet! It works!

That's exactly what I needed. It works like a charm.

Thank you everyone for your help!

Hollis

Remi,

Ok, that didn't work either but it gave me another error that gave me some good information. I got "Error 170. a USE database statement is not allowed in a...

Phil,

I tried what you suggested, but it is giving me an 'incorrect syntax near 'sp_grantdbaccess'. on the first line there: (set @cmd = 'USE DELTEKCP sp_grantdbaccess ' + @loginame +...

AJ

That thought occurred to me, but I don't think that will work with the accounting software. It actually uses the Database Login to login to the accounting software. So they...