Check User have create database permission for MS SQL Server and Azure Sql server using common query

Could you guide me on Check the User has to create database permission for MS SQL Server and Azure Sql server using common query?

Tried the query mentioned in this thread How to view the roles and permissions granted to any database user in Azure SQL server instance?

Below is working only for the Normal MS SQL server but its always returning 0 for Azure Sql server https://docs.microsoft.com/en-us/sql/t-sql/functions/is-srvrolemember-transact-sql?view=sql-server-ver15

Anyone Could you help me on this?

https://stackoverflow.com/questions/67371029/check-user-have-create-database-permission-for-ms-sql-server-and-azure-sql-serve May 03, 2021 at 10:51PM