How do I determine what workstations are accessing a view? 1

[Phil5673]

Can someone tell me how I can find out what workstations are accessing a view on a database? The accessing of the view will be done through an MS Access database file (mdb). Thanks for the help.

Phil Edwards

 

[DrSql]

You can use a profiler for that object (view) you want to monitor and see who is accessing it.

Dr.Sql
Good Luck.

 

[Phil5673]

Thanks. I am still learning SQL Server. I appreciate your help very much.

Phil Edwards