Activity overview
Latest activity by mall2rd
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 / comments
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...
Object reference not set to an instance of an object.
When I attempt to compare the data in any two tables I get the following error "Object reference not set to an instance of an object". I just downloaded and installed version 5.3.0.68. I have tried...