Unanswered: No parameters and arguments were supplied
There is a table with a trigger on it. The trigger calls a stored procedure. The stored procedure has no paramters, and the trigger does not pass any parameters to it.
STILL, when inserting in the table an error occures: "Procedure .... has no parameters and arguments were supplied."
Did anybody came across a similar problem?
PS: Probably it's just a simple minor thing that I am missing, but still, any ideas could help, even if they are the most common ones.
No, that's correct.
But in the mean-time the problem got solved. My colleague bumped in to the same problem at one of our clients, and he solved the problem there by taking out the "GO" from the end of the trigger.
At home, this "procedure" did not solve the problem... probably some different collations may be the cause.
But for now this is OK. I'm still waiting for people who ran into similar "phenomens", because it's rather weard and should not be like this.