- You create a new SQL Server login ID and then assign the login ID as the owner of a database on a Microsoft SQL Server 2012 instance.
- You log in to the SQL Server 2012 instance by using the new login ID.
- You try to view properties of a database in the SQL Server 2012 instance.
Cannot show requested dialog. (SqlMgmt)
An exception occurred while executing a Transact-SQL statement or batch.
The user does not have permission to perform this action. (Microsoft SQL Server, Error: 297)
When you click Database Properties, SQL Server Management Studio (SSMS) runs queries against the following dynamic management views (DMVs):