Script to identify who is using which view and at what time?

Question

Script to identify who is using which view and at what time?

sqldba4u

Hall of Fame

Points: 3414
More actions
November 20, 2012 at 12:59 am

#100136

HI,
There is a requirement to create a script to identify who is using which view and at what time? Its for SQL Server 2000.
Can someone help me here?
Regards
sqldba4u

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

sqldba4u (11/20/2012)
HI,
There is a requirement to create a script to identify who is using which view and at what time? Its for SQL Server 2000.
Can someone help me here?
Regards
sqldba4u

You aren't going to be able to do this with a script. You will have to setup a trace. This is a rather strange requirement. What are you hoping to achieve with this?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

sqldba4u Hall of Fame Points: 3414 More actions · Answer 2

There is requirement to track who is accessing which view and at what time. There are numerous views in databases in SQL 2000 instance which fetches confidential data. DB Owner wants to keep track of it.

Thanks

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

sqldba4u (11/20/2012)
There is requirement to track who is accessing which view and at what time. There are numerous views in databases in SQL 2000 instance which fetches confidential data. DB Owner wants to keep track of it.
Thanks

Again that is very bizarre requirement. This is like asking what users look at tables and at what time. As I said previously, there is no way to do that in a script. You can't capture this data in the past. You will have to setup a trace and capture this information going forward. I don't know how you would capture which user it is though.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/