Error 229 Sql Server 2008 R2
Contents |
360 games PC games
Sql Server 2008 R2 Download
Windows games Windows phone games Entertainment All Entertainment sql server 2008 r2 management studio Movies & TV Music Business & Education Business Students & educators sql server 2008 r2 end of life Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Sql Server 2008 R2 Requirements
Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All
Sql Server 2008 R2 Pricing
Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
here for a quick overview of the site Help Center Detailed answers to any questions sql server 2008 r2 sp3 you might have Meta Discuss the workings and policies of
Sql Server 2008 R2 Versions
this site About Us Learn more about Stack Overflow the company Business Learn more about hiring sql server 2008 r2 service pack 4 developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a https://support.microsoft.com/en-us/kb/323249 community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Permissions issue in SSMS: “The SELECT permission was denied on the object 'extended_properties', database 'mssqlsystem_resource', … Error 229)” up vote 7 down vote favorite 1 Here’s the simplest repro case possible. Create a http://stackoverflow.com/questions/2002773/permissions-issue-in-ssms-the-select-permission-was-denied-on-the-object-exte brand new database. (I'm using SQL 2005.) Create a login, a SQL user, and a table in the new database (see sample code below). Launch SSMS and open Object Explorer, logging in as the newly-created user. Attempt to open the "Tables" folder in the Object Explorer. The Problem Fails with this error message. Message Text: TITLE: Microsoft SQL Server Management Studio Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) For help, click: link ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) The SELECT permission was denied on the object 'extended_properties', database mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229) For help, click: link This user can access the table and the record in the table. But the user cannot access the list of tables in Object Explorer. SELECT USER_NAME() AS CurrentUser, col1 FROM dbo.TestTable CurrentUser col1 ----------- ---- robg_test 1000 The only work-around I have found is to give the user higher-than-n
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the http://stackoverflow.com/questions/6327833/access-error-sql-server-2008 workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join sql server them; it only takes a minute: Sign up access error sql server 2008 up vote 1 down vote favorite I have created a user but when I try to view a database tables, I'm having the following error messages: Please note that I am able to login but not having access to the database. Failed to retrieve data for sql server 2008 this request. (Microsoft.SqlServer.Management.Sdk.Sfc) ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) The SELECT permission was denied on the object 'extended_properties', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229) sql sql-server-2008 share|improve this question edited Jun 13 '11 at 8:32 marc_s 452k938641029 asked Jun 13 '11 at 7:48 learning 2,8572164133 Did you give any permissions to the created users? –Alex Aza Jun 13 '11 at 7:50 yes, the user has been assigned the permissions –learning Jun 13 '11 at 8:49 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote Did you map the login to the user? EXEC SP_Change_Users_Login 'Update_One','user','login',Null share|improve this answer answered Jun 13 '11 at 7:59 steenhulthin 1,90921944 add a comment| Did you find this question interesting? Try our newsletter Sign up for our newsletter and get our top new questions delivered to your inbox (see an example). Subscribed! Success! Please click the link in the confirmation email to activate your subscription. up vote 0 down vote In t