Hello All,

There is a stored procedure sp_fulltext_service which takes the property to
be changed or reset and the value of the property as the parameters.

sp_fulltext_service [ [@action=] 'action' [ , [ @value= ] value ] ]

If value is NULL, sp_fulltext_service returns the current settings.

On EXEC sp_fulltext_service 'upgrade_option' I get the following output :

Configuration Name Configuration Value

upgrade_option     4

Is there any way in which I can get the value of the ‘Configuration Value’
in a variable?

The return type of this stored procedure is ‘int’ which signifies success or
failure.

Regards,

Rajesh