Share via

Stored Procedure not running in VIstual Studio Query Designer

SQLIsGood-7036 176 Reputation points
2021-01-18T16:45:12.577+00:00

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.

57771-visual-studio-error2.png

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,245 questions
0 comments
Accepted answer
  1. SQLIsGood-7036 176 Reputation points
    2021-01-19T00:45:10.457+00:00

    I was able to resolve this issue. I was missing a Stored Procedure, after I added missing SP, it started working.

    Thanks.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.