You cannot directly parameterized the tableName.

The only way you can do that is to make a dynamic SQL Statement. I don't believe variables are allowed in that context, use the following which I've just confirmed works with your procedure:.

More more info refer: By posting your answer, you agree to the privacy policy and terms of service. Stack Overflow Questions Developer Jobs Documentation beta Tags Users. Sign up or log in to customize your list.

Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us. Log In Sign Up. Join the Stack Overflow Community.

Stack Overflow is a community of 7. Join them; it only takes a minute: Invalid object name ' database.

SQL Server Stored Procedure with multiple output parameters - Stack Overflow

John Woo k 34 I don't believe variables are allowed in that context, use the following which I've just confirmed works with your procedure: PeterJ 2, 4 19 You can go with this: Sign up or log in StackExchange. Sign up using Facebook. Sign up using Email and Password.

Post as a guest Name. Stack Overflow works best with JavaScript enabled.

How to: Use Stored Procedures that Take Parameters | Microsoft Docs

Dynamic SQL share improve this answer. MathOverflow Mathematics Cross Validated stats Theoretical Computer Science Physics Chemistry Biology Computer Science Philosophy more 3. Meta Stack Exchange Stack Apps Area 51 Stack Overflow Talent.