hmm ok so thr param is after the where clause. and the string value would be my repeating value for the name of the db correct?

as for the user...

Yes Sir! 🙂

so hate to do this to you but a couple more questions arose once i ran this and it worked as expected.

1. Can i...

yes i did for testing purposes i ran it from the test server which is also the sql server.

thanks

ah nevermind i just figured it out. i can just put in the servername only. apparently local does not work for this...

thanks again great help here as always!

thanks that will be great. I am getting the below which must be a syntax i have wrong. When i put in the servename\instance or local or default. Is there...

hey so another question.

I may want to only select to add them to 1 database.

Can i change line 23 to use the db name and forgo the from...

thanks This should do the trick.

thanks i'll taeka look at it. the issue is that the app for this does has to have a 1 to 1 so groups dont work....

I am still looking for a way to grab the user accounts from a list as well. Ultimately i would like to run this script to generate the new script...

ah nevermind i see that is a variable of sorts. I have it now....thanks for the hand.

ah missed that...so on lines 3 and 5 the name as in your script it gives me an error invalid column name however this should be the name of the...

So i get an incorrect syntax on line 7 concerning the user name? Does not matter if i try to use a sql or domain user. there was also an...

ok that may work. So do i still put in each db name or is it going through all db not under id 4? also for the user name by...