Reconfigure SQL server's advanced settings
The following SQL statement is used to reconfigure the SQL SERVER advanced settings, such as max text repl size.
sp_configure 'max text repl size', 2147483647
GO
RECONFIGURE;
You can also configure this kind of advanced settings via the UI property windows form. Right click on SQL server instance name, select "property" menu item, then click on "Advanced" tab in the "Server properties" windows form.
sp_configure 'max text repl size', 2147483647
GO
RECONFIGURE;
You can also configure this kind of advanced settings via the UI property windows form. Right click on SQL server instance name, select "property" menu item, then click on "Advanced" tab in the "Server properties" windows form.
