How to specify a group on the local machine using CREATE LOGIN

Question

question

Gordy asked Jun 21, '10

How to specify a group on the local machine using CREATE LOGIN

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..

sql-server-2005 t-sql

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-06-21T04:19:22Z

Magnus Ahlkvist answered Jun 21, '10

You can do it with dynamic SQL (with all the disadvantages that brings)

DECLARE @sql nvarchar(300)
SET @sql = 'CREATE LOGIN [' + @@SERVERNAME + '\BOB] FROM WINDOWS'
EXEC sp_executeSQL @sql

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2010-06-21T04:20:11Z

Scot Hauder answered Jun 21, '10

EXEC('CREATE LOGIN [' + @@SERVERNAME +'\BOB] FROM WINDOWS')

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Scot Hauder commented · Jun 21, 2010 at 04:21 AM

got me by 49 seconds

0 ·

question