SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,672 questions
SQL Server error: The Select permission was denied on the object 'extended_properties' from database 'mssqlsystemresource'
nikos3194
0
Reputation points
I'm not able to generate a database script in MS SQL Server Management Studio, it shows me the following error (attached screenshot)
Does anyone know what could be causing it?
{count} votes
-
Erland Sommarskog 110.3K Reputation points2024-08-25T09:53:26.1866667+00:00 One would have to assume that you have insufficient permissions (as the message says). Although it is an odd to a permission error in the resource database.
What permissions do you have? What is your role on the server?
What does "SELECT @@version" report?
-
LiHongMSFT-4306 26,706 Reputation points2024-08-26T02:24:25.9733333+00:00 Hi @nikos3194
We haven't heard back from you yet. Have you checked the permissions mentioned in the above comment?
Sign in to comment
Sign in to answer