How can we help you today?

How can we help you today?

is_srvrolemember not returning correct suggested values

In SQL Prompt, the function is_srvrolemember is not returning the correct suggested values (and sadmin isn't valid).

It should suggest:

sysadmin
serveradmin
dbcreator
setupadmin
bulkadmin
securityadmin
diskadmin
public
processadmin

However, it is showing this instead:

Could this be fixed?

ggeier2 June 19, 2024 16:08

0

Comments

2 comments

Hi @ggeier2

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.

Jon_Kirkwood June 25, 2024 06:50

0
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

Jon_Kirkwood September 23, 2024 07:02

0

Add comment

Please sign in to leave a comment.