5 replies to this topic

[Fabiano Giannetti]

Hi, I have read in an old messagge that some problems with
thread exception could be resolve using the SQL command:
SET NOCOUNT ON, someone could tell me how could I applicate this command ??

It has to be set in a logic function or is a customization
of SQL ?

Thank you very much

Bye

Fabiano

[Ivan Gonzalez]

Hi Fabiano,

I am a SQL Server DBA and we ran into a similar problem. When we upgraded to SQL 2K, a process that was working before stopped. It appears that the process invoked a trigger, so we added the SET NOCOUNT ON statement at the beginning of the trigger and it solved the problem.

By the way could you tell me if you folks invoke SQL Server stored procedures from Pro IV? Or do you know of any other SQL Server users that might know?

Thanks,

Ivan

[Neil Hunter]

Hi Ivan,

Have you had any hassles with thread id exception's on basic tables ie no triggers and no constraints ?

Thanks
Neil

[Neil Hunter]

Unfortunately we have, you running standard or enterprise edition ?