error in the server

hi all ,,
before three days error appeared in my program
descreption this error
(A trigger returned a resultset and the server option 'disallow_results_from_triggers' is true)

I tried solved this error by editing the procedure sp_configure
but its not working with me


in the local DB this error is not existed
this error from server or my db?
and
how I can solved this error ?

thanks for help
eng.Mohannad Elayan

 

PHP:

sp_configure 'disallow results from triggers', 0;-- and try 1 
GO
RECONFIGURE;
GO

 

You won't be able to change that setting. We set disallow_results_from_triggers = true on Microsoft's recommendation:

http://msdn.microsoft.com/en-us/library/ms186337.aspx

"This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible."

The setting was changed on June 4th.

 

hello My Friend,,

Thank for your answer,,

I can't understand ,,

this solution for editing the server setting or DB setting?

I will Try edit this option in my DB But its not working!!

My DB in my Account in DISCOUNTASP.NET HOW can I edit this option in the server ?

Help ME

 

You can't change the value from 1. We don't allow it.