I have seen a strange behaviour 2 or 3 times when technically migrating older Nav solutions to Nav 2009. The users without special sql server roles needed to have sql rights on VIEW SERVER STATE. There are some threads around this topic, but I would like to see the case in a greater contecxt, I'm sure other reader will be also glad about this.
My question to this:
Is this a new prerequisite for Nav 2009?
Traceflag 4616 is not needed anymore, the system views are now used for this?
Does the VIEW SERVER STATE need to be granted manually?
Does the security model of Nav matter?
Is there a difference between db logins and windows logins concerning the topic?
Many thanks in advance.