Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
deco
Starting Member
2 Posts |
 Posted - 2005-08-30 : 10:27:09
|
| Need help on this one.Getting this error Cannot insert the value NULL into column 'nicknames'Merge replication issue on two SQL2000 servers with SP3a applied.Found several pre SP3a fixes such asSelect @@servername comes back as NULL, dosp_dropserver and sp_addserver to fix NULL name issue.Select @@servername returns a proper servername so not an issue. Can get this to work locally but not over a remote connection ?Any one have any other ideas ??ThanksDeco |
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2005-08-31 : 16:45:28
|
| Maybe if you post the DDL of the table that 'nicknames' is in, it would give us a bit more to work with. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-09-04 : 22:18:37
|
| column 'nicknames' probably doesn't allow null values,check the source and destination tables if they both allow null values--------------------keeping it simple... |
|
|
|
deco
Starting Member
2 Posts |
Posted - 2005-09-05 : 07:43:53
|
quote:
Originally posted by jen
column 'nicknames' probably doesn't allow null values,check the source and destination tables if they both allow null values--------------------keeping it simple...
We got this sorted, the replication was using the IP address of the subsciber server rather than the name, so we changed this, and put an entry in the HOSTS file on the publishing server and this sorted the issue.ThanksDeco |
|
|
|
|
|
|
Cannot insert the value NULL into column 'nickname