I wish to a create login for a local group on a server without actually needing the current server name so that I can use the same create statement on multiple servers?
i.e Local Machine is called Kate, allocating a local machine windows group called BOB
Normally I would create as follows in T-SQL
CREATE LOGIN [Kate\BOB] FROM WINDOWS
BUT - On the machine called Rubarb, the same statement won't work. Is there a generic way to specify the local machine to specify a group so it the same statement will work on two different machines?
BTW - I don't happen to have a network group for this and I wish I could easily get one created so just don't go there..