How to store the value of a particular column of result grid displ

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
Look at the FULLTEXTSERVICEPROPERTY system function in Books Online.
Are you sure about the "upgrade_option" configuration setting? It's not
documented. Or is it?
ML
http://milambda.blogspot.com/
|||Thanks ML for replying back.
I'm sorry for the wrong option. But let's say i want to get the value of
load_os_resourses property of the fulltext service without using the
FULLTEXTSERVICEPROPERTY function.
Is there any T-SQL way for doing it by executing the sp_fulltext_service SP?
Regards,
Rajesh
"ML" wrote:

> Look at the FULLTEXTSERVICEPROPERTY system function in Books Online.
> Are you sure about the "upgrade_option" configuration setting? It's not
> documented. Or is it?
>
> ML
> --
> http://milambda.blogspot.com/
|||Why can't you use the function?
Look at the system procedure's definition - you can design your own based on
that.
ML
http://milambda.blogspot.com/