Originally posted by jvilanogales
I tried to use xml_prepare_document stored procedure when lightweight pooling is enabled. It does not work.
I tried to use sp_configure 'lightweight pooling', 0 and reconfigure.... It doesnt work.
Is there a way to disable lightweight pooling without restarting mssqlserver?
it seems u have to restart the server:
Setting lightweight pooling to 1 causes Microsoft® SQL Server™ to switch to fiber mode scheduling. The default value for this option is 0.
lightweight pooling is an advanced option. If you are using the sp_configure system stored procedure to change the setting, you can change lightweight pooling only when show advanced options is set to 1. The setting takes effect after stopping and restarting the server.