Stored Procedure not running in VIstual Studio Query Designer

SQLIsGood-7036 176 Reputation points

Visual Studio: 2017 Shell Integrated
SQL Server 2016 Standard

Problem: In Dataset Properties ---> Select Stored Procedure --> Query Designer---> When I try to run stored procedure, I only get the column names, but no output. Please see screenshot below.

In Dataset Source, I am able to Test Connection to that Database successfully. I am also able to run that Stored Procedure in SSMS successfully.

Thanks for your help.


Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,674 questions
0 comments No comments
{count} votes

0 additional answers

Sort by: Most helpful