When writing an ALTER ROLE command, MyRole ADD MEMEBER MyUser emphasizes ADD and writes what was expected "WITH". ADD MEMBER does not recognize at all. Why?

    1 answer 1

    And what is your version? Carefully read the documentation - this construct is supported starting from SQL 2012:

    http://msdn.microsoft.com/ru-ru/library/ms189775%28v=sql.105%29.aspx

    For 2008, the sp_addrolemember command is used.

    • The fact of the matter is that I have 2012. And on both computers the same problem. - Vasily Koshelev
    • And the level of compatibility for the database is set? if 100 (2008), it will not fly either, most likely. - minamoto
    • understood accepted. Used addrolemember, thanks! - Vasily Koshelev