How to create Fixed Server Role in SQL Server ?

Posted by Mahesh Gupta on November 25, 2010 Leave a comment (0) Go to comments

YES, we can create SQL Server Roles in SQL Server (2011) Denali onwards. Starting from SQL Server Denali you can create user-defined server roles and add server-level permissions to the user-defined server roles. We can not create  user defined roles in any prior release which includes (SQL Server 2008 R2, SQL Server 2008, 2005,2000,7.0).

How to create User defined Server Role in SQL Server ?

I have already posted an article on this, check this out.

All Blog Posts, DBA, Popular, SQL 2012, SQL 2012 New Features, Tutorials ,
EOF - How to create Fixed Server Role in SQL Server ?, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *

*

CAPTCHA Image

*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.