To create login in many servers.

Question

To create login in many servers.

Saravanan T

SSCrazy

Points: 2506
More actions
March 31, 2010 at 2:20 am

#213338

Hi,
Its an interview question.How to create a login in 500 servers at one shot????
Regards,
Saravanan

Viewing 6 posts - 1 through 5 (of 5 total)

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

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 1

Just saw this, and didn't want to leave it unanswered.

If you are on 2005, and can't use PoSh, I'd actually script this with SQLCMD and use VBScript to call SQLCMD with a list of users and servers.

In PoSh, similar concept. You'll connect to each instance, hopefully with a list of servers, and then run execute the create method on each.

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 2

Quick trick, in SSMS press CTRL+ALT+G to view Registered Servers, if they are grouped you can right click on the group, new query and that instance of the query will be executed on all servers in that group.

😎

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

Eirikur Eiriksson (4/24/2015)
Quick trick, in SSMS press CTRL+ALT+G to view Registered Servers, if they are grouped you can right click on the group, new query and that instance of the query will be executed on all servers in that group.
😎

Eirikur, I can't tell you how many times I've told people about the running SQL against multiple servers using the group. They're always so surprised and can't believe it's that easy.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 4

Ed Wagner (4/25/2015)
Eirikur Eiriksson (4/24/2015)
Quick trick, in SSMS press CTRL+ALT+G to view Registered Servers, if they are grouped you can right click on the group, new query and that instance of the query will be executed on all servers in that group.
😎
Eirikur, I can't tell you how many times I've told people about the running SQL against multiple servers using the group. They're always so surprised and can't believe it's that easy.

I know Ed, such useful things as standardizing colour coding for groups, having DAC groups, importing and exporting groups as .regsrvr etc. just don't seems to get through to them.

😎

Maybe you should do a little write up on this, that would be useful!;-)

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 5

Eirikur Eiriksson (4/24/2015)
Quick trick, in SSMS press CTRL+ALT+G to view Registered Servers, if they are grouped you can right click on the group, new query and that instance of the query will be executed on all servers in that group.
😎

I've known that, though I'd use Red Gate's MultiScript to do it. In this case, I wanted one machine for testing, but that would work for multiple instances.