Friday, May 16, 2008

Sql Server Data Management Views

I have recently finished watching DAT320 My Top Ten DMVs by Greg Low from Teched 2007.
The DMV are very powerful. One of the commom questions is what is the difference between DMV and a DMF. THE DMF's are DMV's with parameters.

It is important to note that additional permissions are required to run DMV. These permissions are: -
  • select permission
  • plus view server state (server scope)
  • and view database state for (database scope)

No comments: