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.
Thank you for your patience whilst this was worked on.
A fix has been included in version V10.14.22
Using Is_SrvRoleMember will now return the expected input options
Download for this version can be accessed here:
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.22.11347.exe
Release notes:
https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-14-release-notes