Server Level roles

  • Can we create server level roles in 2008R2?

    I am not getting option 'New Server Role' when i right click server roles.

    But How come this document shows can do it.

    http://cm-bloggers.blogspot.com/2010/12/creating-user-defined-server-role-in.html

    Thanks Experts!

  • Sqlism (7/20/2012)


    Can we create server level roles in 2008R2?

    I am not getting option 'New Server Role' when i right click server roles.

    But How come this document shows can do it.

    http://cm-bloggers.blogspot.com/2010/12/creating-user-defined-server-role-in.html

    Thanks Experts!

    sql server denali was the code name for sql server 2012. its a new feature in SQL 2012 to create custom server level roles instead of just the database level roles we can currently define.


    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

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

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