Object reference not set to an instance of an object.

• 
  Hi,
  
  Thanks for reporting the problem. Would you be able to post the table creation scripts for your tables so we can attempt to reproduce this in-house?
  
  Thanks!
  
  David Atkinson
  Red Gate Software

  David Atkinson January 29, 2007 05:26

  - 0 +
• 
  The structure for one of the tables I tried is below.
  
  CREATE TABLE [Channels] (
  [ChannelID] [int] IDENTITY (1, 1) NOT NULL ,
  [ChannelName] [varchar] (50) COLLATE Compatibility_52_409_30003 NOT NULL ,
  [ChannelAlias] [varchar] (16) COLLATE Compatibility_52_409_30003 NOT NULL ,
  [CountryID] [int] NULL ,
  [LanguageID] [int] NULL ,
  [ApplyOnLineURL] [varchar] (255) COLLATE Compatibility_52_409_30003 NULL ,
  [Private] [tinyint] NULL ,
  [RootSite] [tinyint] NULL ,
  [ISOLocale] [varchar] (5) COLLATE Compatibility_52_409_30003 NULL ,
  [ParentChannelID] [int] NULL CONSTRAINT [DF_Channels_ParentChannelID] DEFAULT (0),
  [AllowJobPostsToAllCompanyBoards] [bit] NOT NULL CONSTRAINT [DF__HChannels__Allow__6A669BCA] DEFAULT (1),
  [ResumeActionsArePrivate] [bit] NOT NULL CONSTRAINT [DF__HChannels__Resum__6B5AC003] DEFAULT (0),
  [ChannelAccessibility] [tinyint] NOT NULL CONSTRAINT [DF__HChannels__Chann__6C4EE43C] DEFAULT (1),
  [ChannelTypeID] [int] NULL ,
  [ChannelStatusID] [int] NULL ,
  [DateCreated] [smalldatetime] NOT NULL CONSTRAINT [DF__HChannels__DateC__6D430875] DEFAULT (getdate()),
  [DateModified] [smalldatetime] NULL CONSTRAINT [DF__HChannels__DateM__6E372CAE] DEFAULT (getdate()),
  [CHSReport] [bit] NOT NULL CONSTRAINT [DF_Channels_CHSReport] DEFAULT (0),
  [MonthsUntilResumeExpiresOnChannel] [smallint] NULL ,
  CONSTRAINT [PK_Channels] PRIMARY KEY CLUSTERED
  (
  [ChannelID]
  ) WITH FILLFACTOR = 90 ON [PRIMARY] ,
  CONSTRAINT [UQ_ChannelAlias] UNIQUE NONCLUSTERED
  (
  [ChannelAlias]
  ) WITH FILLFACTOR = 90 ON [PRIMARY]
  ) ON [PRIMARY]
  GO

  mall2rd January 30, 2007 09:54

  - 0 +
• 
  I am getting a the same problem.

  maddba March 23, 2007 15:18

  - 0 +
• 
  The issue here is that SQL Data Compare does not support the collation that you are using (Compatibility_52_409_30003).
  
  A workaround is to change the collation on the offending column(s), either permanently, or temporarily using the syntax:
  
  ALTER TABLE myTestTable ALTER COLUMN [myvarcharcol] VARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
  
  Maddba, could you please confirm which collation you have on your column? There is a possibility that we can fix these if we find out which collations are being used that we aren't currently supporting. Unfortunately we haven't found a definitive list of all supported collations from Microsoft so a few have been omitted.
  
  You can find out what collations are being used as follows:
  
  SELECT name, collation FROM syscolumns WHERE [id]=object_id('myTestTable')
  
  Please let me know if this doesn't work for you.
  
  Kind regards,
  
  David Atkinson
  Red Gate Software

  David Atkinson March 27, 2007 09:17

  - 0 +

Add comment

Please sign in to leave a comment.