Friday, September 07, 2012 12:51 PM
I was asked to check all databases indexes usage through DMV. I have access to DMVs, but I have not access to all DBs. Is there any way how to get to DMV index,table statistics without SELECT access to DB? there are some confident data and I have not permission to see them.
thanks a lot
Friday, September 07, 2012 1:44 PM
There is no way. You need SELECT permission on the database to complete this task.
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Friday, September 07, 2012 4:37 PM