Hi,
Is there a way that I can capture user access to a specific database, into a table perhaps. I'm just looking to record date and time of login and which database is accessed.;
Any help would be appreciated.
Thanks
Answer by Jeff Moden ·
I believe you can do database level login triggers even in the standard edition.
Answer by JohnM ·
Depending on what version of SQL Server you are using you can use an Audit to track this information. You can also use extended events to watch for locks on the database. If there's a lock then they touched the database. If you want specific tables, using an Audit is probably better suited here.
Issue while upgrading SQL Server 2012 express to SQL Server 2016 express edition.
For sql server 2016 memory optimized databases is row versioning ON by default.
What is the most optimal use of the IN-clause from C# code
SSIS Package Foreach Loop Container not finding files when deployed (fine in DEV)