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.
分类:
S.SQLServer2005
· Linux系列：如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列（二）：开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识（上）
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布：重大改进与新特性概览！
· AI与.NET技术实操系列（二）：开始使用ML.NET
· 单线程的Redis速度为什么快？
2005-02-02 SQL Server 2000 Service Pack 4 & Reporting Services Service Pack 2 (Beta)