Lawrence Moore (5/23/2011)
Hi Eric,Many thanks for your post.
It is true that DMVs offer lots of useful information, some of which could be applied for requirements discussed in my article.
However, DMVs typically require elevated user permissions, such as VIEW SERVER STATE.
Regards,
Lawrence
I'd think that a process, which does something like querying for changes in a table and selecting the rows out to another table, would not be running under an application or user account. It would probably the SSIS or the SQL Agent account, in which case it would be OK to grant it VIEW SERVER STATE permission.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho