SSC-FDM-TS0003
XP_LOGININFO mapped to custom UDF
Description
This message is shown when the XP_LOGININFO procedure is executed and returns the following set of columns (See SQL SERVER documentation for more info)
To replicate this behavior, there is a query that select the columns from the APPLICABLE_ROLES view in Snowflake, which returns the following set of columns (See SnowFlake documentation for more info)
SQL Server original columns are mapped as shown in the next table. They may be not completely equivalent.
Example code
Input code:
Output code:
Recommendations
If you need more support, you can email us at snowconvert-support@snowflake.com
Last updated