Limitations and restrictions

Windows Unicode-only collations can only be used with the COLLATE clause to apply collations to the nchar, nvarchar, and ntext data types on column level and expression-level data. They can't be used with the...

I hope the text below helps you understand.

SQL Server provides server-level roles to help you manage the permissions on a server. These roles are security principals that group other principals....