xp_loginconfig extended stored procedure issue

Question

Azure SQL Database Managed Instance

There is a issue with extended stored procedure xp_loginconfig with should returns information about login security configuration.

exec [master].sys.xp_loginconfig

Msg 2812, Level 16, State 62, Line 2
Could not find stored procedure 'master.sys.xp_loginconfig'.

but when we expand the procedure tree we see it exists.
This is expected or a bug ?

Answer 1

Hi, @Mariusz Siedlecki Welcome to the Microsoft Q&A forum, Thanks for posting your question.

The document xp_loginconfig says this is only supported for SQL Server and has the note to avoid using this feature,

Similarly to other extended stored procedures xp_loginconfig is on a deprecation path and is not supported on Managed Instance:

For more information please refer here

Hope this will help. Please let us know if any further queries.
Regards
Geetha

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer.