You are currently offline, waiting for your internet to reconnect

Error message when you try to run a query in SQL Server 2008 or in SQL Server 2008 R2: "Msg 916, Level 14, State 1, Line 1"

SYMPTOMS
In Microsoft SQL Server 2008 or in SQL Server 2008 R2, you may receive the following error message:
Msg 916, Level 14, State 1, Line 1
The server principal "dm_db_script_level_Perms_LOGIN" is not able to access the database "model" under the current security context.
This problem occurs when you try to run the following query to view the records in the sys.dm_db_script_level view:
SELECT * FROM sys.dm_db_script_level
CAUSE
This problem occurs when you have the View Server State permission. This permission does not enable you to view the records in the sys.dm_db_script_level view.
WORKAROUND
To work around this problem, run the query by using the System Administrator permission.
"SQL Server 2008 Database Engine" SQL2008RelNoteDatabaseEngine
Properties

Article ID: 955826 - Last Review: 03/19/2009 22:30:05 - Revision: 2.1

Microsoft SQL Server 2008 Developer, Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2008 Express, Microsoft SQL Server 2008 Express with Advanced Services, Microsoft SQL Server 2008 Standard, Microsoft SQL Server 2008 Web, Microsoft SQL Server 2008 Workgroup, Microsoft SQL Server 2008 R2 Datacenter, Microsoft SQL Server 2008 R2 Developer, Microsoft SQL Server 2008 R2 Enterprise, Microsoft SQL Server 2008 R2 Express, Microsoft SQL Server 2008 R2 Express with Advanced Services, Microsoft SQL Server 2008 R2 Standard, Microsoft SQL Server 2008 R2 Standard Edition for Small Business, Microsoft SQL Server 2008 R2 Workgroup

  • sql2008relnotedatabaseengine sql2008relnote kbtshoot kberrmsg kbprb KB955826
Feedback