0

I want to add a new user-defined Server Role to my SQL Server instance, but the menu doesn't show all options, it only shows this:

enter image description here

Instead of this :

enter image description here

and I also tried the T-SQL command to create the server role but it keep showing the message

Incorrect Syntax near 'AUTHORIZATION', expecting id ,quoted_id or to.

Please Help ASAP.

1 Answer 1

2

CREATE SERVER ROLE only apply to SQL Server 2012 through current version.

See on MSDN: CREATE SERVER ROLE (Transact-SQL)

1
  • Thanks a lot :) you saved me from a tons of wasted minutes. Commented Oct 29, 2015 at 9:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.