Jan 9, 2009

sql server 2000(publisher) vs sql server 2005(subscriber) with difference COLLATE

1. SQL server 2000 as publisher and distributor role .
2. Add sql server 2005 as subscriber(cannot browser database , just type the database name into destination database name in EM) in sql sql server EM.
3. Create tables in sql server 2005 with same COLLATE column specify in sql server 2000.
4. Add publication article with no create object option.

solve problem:
無法大量載入,大量資料流不正確地指定為已排序。
(來源: 192.168.1.1 (資料來源); 錯誤號碼: 4819)
---------------------------------------------------------------------------------------------------------------
函數順序錯誤
(來源: 192.168.1.1 (資料來源); 錯誤號碼: S1010)

0 意見: