SQL Server 2005 Error "The user does not have permission to perform this action" - clears up after r
Posted
by Sylvia
on Stack Overflow
See other posts from Stack Overflow
or by Sylvia
Published on 2010-04-21T18:19:52Z
Indexed on
2010/04/21
18:23 UTC
Read the original article
Hit count: 358
sql-server-2005
We're getting the error "The user does not have permission to perform this action" during times of heavy load (regularly, when a trim job occurs). The error clears up when the service accessing sql server is restarted, so it's obviously not a real permissions problems.
There's a possibility that the problem is occurring when we're trying to query dm_tran_active_transactions and sys.dm_tran_session_transactions.
Any ideas of good places to start looking?
thanks for any insights...
© Stack Overflow or respective owner