November 19, 2013 at 2:54 pm
I'm trying to set up Replication, and the first step is adding the distributer. I run the code:
use master
exec sp_adddistributor @distributor = N'myServer', @password = N''
GO
When I run this, I get the following error:
Msg 4188, Level 16, State 1, Procedure sp_MScreate_distributor_tables, Line 112
Column or parameter 'alert_error_text' has type 'ntext' and collation 'Latin1_General_100_CI_AS_SC'. The legacy LOB types do not support Unicode supplementary characters whose codepoints are U+10000 or greater. Change the column or parameter type to varchar(max), nvarchar(max) or use a collation which does not have the _SC flag.
The error is in the proc sp_MScreate_distributor_tables that is called. I'm having trouble finding this proc anywhere.
The server in question is a stand-alone server (not clustered, always-on, or anything fancy-smancy) running Enterprise edition. The version is 11.0.3381.
I haven't been able to find out much online pertaining to this particular error. Any thoughts on how to handle this? Any solutions that does not involve changing the collation of the server?
November 20, 2013 at 6:21 am
Based solely on the error is your default sql collation "'Latin1_General_100_CI_AS_SC'"?
If so the last line in the errors tells you that you must use a collation that does not include supplementary characters (SC).
this topic explains the use of SC, basically unless you need support for SC you should change your collation. Which is not that simple the distribution database is a system database which mean mean re-installing SQL server or rebuilding the master database:
http://technet.microsoft.com/en-us/library/ms143726.aspx
MCITP SQL 2005, MCSA SQL 2012
November 21, 2013 at 7:43 am
Yes, that's the collation.
What a pain to change it. There has to be some way to get this done without changing it.
Any ideas on where the proc "sp_MScreate_distributor_tables" is located? That seems to be a mystery as well.
November 21, 2013 at 10:21 am
one option if you have another SQL server available is to use that as a remote distributor.
I'm not sure what db those procs are in but I would suspect that it would be in the master database.
MCITP SQL 2005, MCSA SQL 2012
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply