I am new. I would like to seek your helps and expertise on how to terminating all users who uses a database table. I have a AdventureWord database, and I have a table named Reporting in this database. I have users who use the reporting database. My question are
- I would like to know all of the user name who use the Reporting table of the Adventurework database.
- I would like to have a query to terminate the jobs of all of the above users who use the Reporting table of the Adventurework database.
I would like to seek your helps if you could help me with the two above items.