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

[ori_g]

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?

[YuriP]

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