I dont't see how I can use this procedure in my code...

I've tried exec sp_MSforeachdb @command1='exec mySP' but it's the same result.

Can you explain me ?

Thank's

Gaëlle 

Hello,

Has someone resolve this error ? I have the same message : error: 16954 "Executing SQL directly; no cursor." when I execute a trace of all exceptions.

I don't find the...

Thank you, I've find the command :

ALTER DATABASE TEST SET CURSOR_DEFAULT LOCAL;