I am curious to know if there is a way that SQL Server (or actually SSMS) can show me who is connected to my database in SQL Server?
Other questions I guess I have, can SSMS show me any sort of data logging activity?
Meaning as something that is built into its features, not requiring me to set up tables and create anything.
can it tell me if a record was changed, when it was change, who changed it.
or can it even tell if objects like a new table was created, when and by who.
I have read some conversations about the activity monitor (but the conversation was back and forth and it got beyond what I could understand)
and I have a book "SQL Server 2019 A Beginners Guide" (first we should talk about properly defining a beginner)
but the book talks about the system catalog and catalog views but quickly out paces me.
As always thanks for any information or help