Microsoft SQL Server, Error: 229 Hatası ve Çözümü (MS SQL)
The SELECT permission was denied on the object 'types', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229) şeklinde hata alıyor iseniz sebebi kullanıcınızın "sysadmin" yetkisi olmadığı içindir. Çözüm: Step1 :- Go to the properties account Step2:- Choose User Mapping Step 3:- Choose Respective DB Step 4:- Remove db_denydatareader (uncheck) Step 5:- Click Ok and Refresh KAYNAKLAR: https://sadullahkeles.wordpress.com/2011/08/11/the-execute-permission-was-denied-on-the-object-sp_enable_sql_debug-database-mssqlsystemresource-schema-sys-microsoft-sql-server-error-229/ http://www.msqlserver.net/2012/11/the-select-permission-was-denied-on.html