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.
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.
1 commenti:
ah beh, hanno impiegato 5 anni per risolvere un bug del genere... c'รจ proprio da andarne fieri!
Post a Comment