Devart Forums

Posted: **Tue 27 Jun 2017 15:45**

I have just started using Studio for SQL Server and am connecting to a DB I have been connecting to via SSMS for years using SQL Server Authentication.

I am able to access the Database, but when I try and run a query that works in SSMS - A simple

Code: Select all

SELECT * FROM MyTable

, I get the following error:

Code: Select all

1 Procedure sp_cursoropen. The EXECUTE permission was denied on the object 'sp_cursoropen', database 'mssqlsystemresource', schema 'sys'. SQL.sql 1 1

Again, the same query works on the same DB in SSMS. What can I do to resolve this?

Posted: **Thu 29 Jun 2017 10:05**

Hello,

You could try to do the next:
Turn Off Paginal Mode on Data Grid toolbar. Execute you query again.
If error message is absent, please open Main Menu -> Tools -> Options -> Data Editor -> General and turn Off checkbox Use Paginal Mode By Default.
Please, notify us if these actions were unsuccessful.

Best regards,
Yuri

Devart Forums

Cannot execute query that works in SSMS - EXECUTE permission denied sp_cursoropen

Cannot execute query that works in SSMS - EXECUTE permission denied sp_cursoropen

Re: Cannot execute query that works in SSMS - EXECUTE permission denied sp_cursoropen