Jamyy's Weblog

Microsoft SQL Server 2000 Replication Notes

解決啟用 Replication 後, text / ntext / image 欄位無法儲存大於 65536 bytes 的問題

啟動 Query Analyzer, 執行:

sp_configure 'max text repl size', 2147483647
go

RECONFIGURE WITH OVERRIDE
go

參考資料: http://www.mssqlcity.com/FAQ/Replic/RepImage.htm

解決 The agent is suspect. No activity reported within the last 10 minutes. 的問題

SQL Server Enterprise Manager -> Replication Monitor (right click) -> Refresh Rate and Settings
Inactivity threshold = 9999

參考資料: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q285106

解決 The process could not bulk copy into table "table_name" 的問題

SQL Server Enterprise Manager -> Tools -> Replication -> Create and Manage Publications...
Select your publication -> Properties and Subscriptions
Snapshot -> Character mode format

ps. 設定為 "Character mode format" 之後在長時間的 Push Subscription 過程中, 是能有效降低 process could not bulk copy into table 的出現機率, 不過實測結果並不是百分之百有效... :(