Deploy Security Changes with Copy-SqlLogin

Question

Post reply

Deploy Security Changes with Copy-SqlLogin

Steve Jones - SSC Editor

SSC Guru

Points: 738127
More actions
October 31, 2016 at 10:21 pm

#400966

Comments posted to this topic are about the item Deploy Security Changes with Copy-SqlLogin

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

trangen1 SSC-Addicted Points: 495 More actions · Answer 1

IS THERE a wild card to do all of them at once????, instead of onesie-twosies, one line at a time.

Thanks

The Happy DBA SSC-Addicted Points: 427 More actions · Answer 2

That was going to be my question... have you had any reply to your question?

The Happy DBA!!!

trangen1 SSC-Addicted Points: 495 More actions · Answer 3

Negative Sir!

No reply yet. BUT and that's a BIG BUTT, that's what she said, "I just posted it a few minutes ago" so give it a little time.

This is Captain Roger, Over!

This is Captain Over, Roger! (joking from the movie Airplane)

gbargsley SSCommitted Points: 1514 More actions · Answer 4

Yes, the command will copy all logins or a specific one or filter out specific ones. Check out the examples at.

https://dbatools.io/functions/copy-sqllogin/

trangen1 SSC-Addicted Points: 495 More actions · Answer 5

trangen1

SSC-Addicted

Points: 495

November 1, 2016 at 9:29 am

#1909908

Very Nice!

Thank you Sir!

Steve Jones - SSC Editor SSC Guru Points: 738127 More actions · Answer 6

AFAIK, you can do all, exclude some, or pick some. No wildcards. Please correct me if that's wrong.

ctrlb Old Hand Points: 386 More actions · Answer 7

Thank you, gbargsley! Steve, you are correct, you do all, exclude some, or pick some. No wildcards at this time. If anyone would like wildcard support, please file a request at https://github.com/sqlcollaborative/dbatools/issues and we'll queue it up.

Chrissy
Founder, dbatools.io

Deploy Security Changes with Copy-SqlLogin

Cookies on SQLServerCentral