• Eirikur Eiriksson - Sunday, March 4, 2018 7:05 AM

    Can you post the DDL for the AllDocs table please.
    😎

    This method is what I recommend, just wondering why you are getting NULL values for the Stream_id. Could be permissions issue, can you check that?
    Is the new server a cluster?

    Thanks Eirikur. 

    Strem_ID was never Null

    CREATE TABLE [dbo].[AllDocs](
        [ID] [bigint] IDENTITY(1,1) NOT NULL,
        [Stream_ID] [uniqueidentifier] NOT NULL,
        [FileName] [nvarchar](100) NOT NULL,
        [ToProcess] [int] NOT NULL,
        [CreateDate] [datetime] NOT NULL,
    CONSTRAINT [PK_AllDocs] PRIMARY KEY CLUSTERED
    (
        [ID] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]

    GO

    ALTER TABLE [dbo].[AllDocs] ADD DEFAULT ((0)) FOR [ToProcess]
    GO