Posts
Sort by recent activity
SQL Prompt does not recognize IS_ROLEMEMBER function during format (9.5.16.11294)
SQL Prompt formats thisSELECT IS_ROLEMEMBER('db_owner') ;
to
SELECT [IS_ROLEMEMBER]('db_owner') ;Which becomes invalidBelow is some of the other function from https://docs.microsoft.com/en-us/sql/t...
SQL Prompt misformats IS_ROLEMEMBER function (version 9.5.16.11294)
SQL Prompt formats SELECT IS_ROLEMEMBER('db_owner') ;toSELECT [IS_ROLEMEMBER]('db_owner') ;Which becomes invalid.Some other functions from sitehttps://docs.microsoft.com/en-us/sql/t-sql/functions/f...
SQL Prompt misformats IS_ROLEMEMBER function (version 9.5.16.11294)
SQL Prompt formats SELECT IS_ROLEMEMBER('db_owner') ;toSELECT [IS_ROLEMEMBER]('db_owner') ;Which becomes invalid.Some other functions from sitehttps://docs.microsoft.com/en-us/sql/t-sql/functions/f...