SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 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 120.2K Reputation points MVPAug 25, 2024, 9:53 AM 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 31,471 Reputation pointsAug 26, 2024, 2:24 AM 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