How to store the value of a particular column of result grid displayed by running a stored proce

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

1. You can insert the output of a stored procedure into a table you create and select from that table.

2.

DECLARE @.return int

SELECT @.return =FULLTEXTSERVICEPROPERTY('IsFulltextInstalled')

SELECT @.return

3. You can right-click a system stored procedure, click modify and see if you can rewrite its code as a select.