Procedure has no Parameters and Arguments were Supplied.


Oh this is silly error , Junior DBA was execution one procedure shared by application team and he got this error. He was clueless and he was new he didn't know what to do.
Error:
Msg 8146, Level 16, State 2, Procedure xxxx, Line 0
Procedure xxx has no parameters and arguments were supplied.


Let check whats the issue.
I created one stored procedure 'Error_test' , Below is the script

After deploying I executed procedure below and here is my error. Error clearly says procedure has no parameter. What does this means???

Procedure is taking "GO" as parameter , So make sure while calling you should write any keyword or any variable which can be consider as parameter


So what's the correct way. You must put GO in second line or press enter just before "GO" and issue resolved
So junior DBA , Please read errors any you can fix it by your self

11 comments:
Write comments
  1. How to pass argument to SP and access it inside to procedure?

    ReplyDelete
    Replies
    1. Reference: http://msdn.microsoft.com/en-us/library/ms187926.aspx

      CREATE PROCEDURE usp_add_kitchen @dept_id int, @kitchen_count int NOT NULL
      WITH EXECUTE AS OWNER, SCHEMABINDING, NATIVE_COMPILATION
      AS
      BEGIN

      UPDATE dbo.Departments
      SET kitchen_count = ISNULL(kitchen_count, 0) + @kitchen_count
      WHERE id = @dept_id
      END;

      Delete
  2. Thanks a lot it is working...Grt

    ReplyDelete
  3. Wow Da weiss man, wo es hingehen muss Viele Grüsse Mirta 토토사이트

    ReplyDelete
  4. our bedding collections consists of beddings that come from new york and this are great bedding collections` soi lô đề chuẩn

    ReplyDelete
  5. If you've been in school or are planning on going back, then you know that one of the main components is essay writing. In fact, given the amount of new technology available, you could be wondering why you should write an essay in the first place? For one thing, besides being a requirement of your course, writing an essay allows you to dig further into a topic than even a 3 hour lecture could. Adalina Mae Author

    ReplyDelete
  6. Some genuinely interesting information, well written and broadly user pleasant. ดูหนังออนไลน์

    ReplyDelete
  7. Good day! This post couldn’t be written any better! Reading this post reminds me of my good old room mate! He always kept talking about this. I will forward this page to him. Pretty sure he will have a good read. Thank you for sharing! ดูหนังออนไลน์

    ReplyDelete
  8. berlin… [...]u Not every blog has got the facts right but this one seems to have managed t ld[...]… Counseling

    ReplyDelete
  9. you employ a excellent weblog here! do you need to make some invite posts in this little weblog? waklov devient

    ReplyDelete
  10. there are portable wine coolers which also fit in a small office space. i use them in my home office** anavar online

    ReplyDelete

Please do not enter spam links

Services

More Services