October 12, 2020 at 12:00 am
Comments posted to this topic are about the item Upgrading User Information
October 13, 2020 at 12:14 am
Hello Steve,
The sys.sysusers view still works in SQL 2019-both on premise and on azure sql. sys.database.principals is a better view with more information. It depends what information you are looking for from the view.
I noticed syslogins view which works in SQL 2019 indicates a user has dbaccess even if it is denied connection to db after creation. There may be a bug in the evaluation version. But I am curious to find out.
October 13, 2020 at 1:55 am
All the older views are deprecated, but they are not likely to be enhanced, nor removed. You should be using the modern view.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply