SQL 2005 - Sysprocesses Permission

SQL 2000 default permissions allowed user (without System Administrator Rights) to obtain the list of processes querying sysprocess.

SQL 2005 doesn't allow it and you must explicit grant VIEW SERVER STATE permission to users.
Tags: ,

About author

Vittorio Pavesi


  1. ah beh, hanno impiegato 5 anni per risolvere un bug del genere... c'รจ proprio da andarne fieri!

Post a Comment