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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy