We have AD groups as logins, and a few sql logins in our databases. They all have to switch to the app database as when they use VS or SSMS, they default to the master database.
alter login xxx with default_database = [YY]
Msg 40517, Level 16, State 1, Line 1
Keyword or statement option 'default_database' is not supported in this version of SQL Server.
Completion time: 2021-05-24T17:38:43.6054597-05:00
Is there a way to set a default database for users in azure sql?
Thank you!