Post reply

Checkbox group in Security and Search

  • May 4, 2012 at 2:32 am

    #255841

    When adding a group in SQL Server 2008 R2 and clicking on "Search" to do this, the checbox "Group" is not checked in "Object Types" by default.

    It is annoying to type in domain\group and then click "Check names" button just to find that the user does not exists because it is a group.

    How do you or is there a way to set this to allways be checked?

  • May 4, 2012 at 9:31 am

    #1483653

    Are you using Check Names just to validate? i.e. are you usually provided the complete domain\account info? If so, while the GUI is good for some things, these types of things are much more efficiently done using T-SQL:

    CREATE LOGIN [domain\account] FROM WINDOWS WITH DEFAULT_DATABASE=[master];

    -- add to fixed server roles here

    -- create database user statements here

    -- add to database roles here

    You could install the SSMS Tools Pack or buy redgate SQL Prompt[/url] (looks pricey, but worth every penny), both offer code snippet functionality, to gain easy access to the syntax in a query window.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • May 7, 2012 at 8:23 am

    #1484076

    I am doing this as I am enterring a new user and to check if I spelled the name correctly, i.e. fetching group from AD.

    I would like to have that checkbox allways to be checked if it is possible

  • May 7, 2012 at 1:13 pm

    #1484186

    If you spell it incorrectly the CREATE LOGIN command will let you know via refusing to create a login off a non-existent AD group. Sorry, I can't help with the GUI issue.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • May 11, 2012 at 12:07 am

    #1486103

    Thanks anyhow. I'll address Microsoft with this

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

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