0

I'm getting a SQL Server error on a stored procedure (although it appears to run and run correctly). When I view the stored procedure call in my code, it is underlined, and the highlighted error message says: "Procedure sp_ReferenceSite has no parameters and arguments were supplied."

My procedure is called like this:

execute dbo.sp_ReferenceFieldwork @refColumnName='Comment', @FldWkID=@FieldInvId, @reference=@ref output

and the procedure is defined as

CREATE  PROCEDURE [dbo].[sp_ReferenceFieldwork]
@refColumnName varchar(100),
@FldWkID int,
@reference varchar(8000) output
AS

As far as I can tell, all the cases are correct, the number of parameters are correct, the field types are correct. What's the problem? Or, at least, what might be the problem?

Improve this question
2
  • Is this Intellisense giving an error? Commented Sep 24, 2010 at 20:21
  • Yes, from within SQL-Server Managment Studio. Commented Sep 24, 2010 at 20:22

1 Answer 1

Reset to default
3

If it runs OK, then it's probably the Intellisense cache.

How to refresh it

It's brain dead: take it outside and shoot it. Replace with Redgate SQL prompt or similar.

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

CTRL+SHIFT+R will refresh the Intellisense cache.
@JNK: Thanks. I despise it and use SQL prompt :-)
I've heard that's better but in my environment we are using standard MS tools for the most part :(

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.