is_srvrolemember not returning correct suggested values
ggeier2
Posts: 10 Bronze 1
in SQL Prompt
In SQL Prompt, the function is_srvrolemember is not returning the correct suggested values (and sadmin isn't valid).
It should suggest:
However, it is showing this instead:
Could this be fixed?
It should suggest:
- sysadmin
- serveradmin
- dbcreator
- setupadmin
- bulkadmin
- securityadmin
- diskadmin
- public
- processadmin
However, it is showing this instead:
Could this be fixed?
Tagged:
Answers
Thank you for pointing this out. I can see from this page that the suggestions should be as you advise.
https://learn.microsoft.com/en-us/sql/t-sql/functions/is-srvrolemember-transact-sql?view=sql-server-ver16
I'll escalate this to the development team for their awareness and request for a fix in a future release.
Will try and keep this post updated with any feedback from the developers and/or a fix release version.