sql server full text search: 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

---

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

[quoted text, click to view]