Hi Eirikur,

The result is,

TABLE_NAME MAX_VAL

dbo.MAP_MONTHNULL

dbo.MAP_HOUR 19606721

dbo.MAP_DAY 5997571

dbo.MAP ...

:Wow: Thanks...... let me try

or wich part can i change INT?

so i must change from INT to BigINT?

Hi Eirikur,

Sorry wrong file, i re attached file for DDL.

USE [genesys_datamart]

GO

/****** Object: Table [dbo].[MAP_MONTH] Script Date: 11/15/2016 17:58:19 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE...

Hi Eirikur,

fya

Hi Eirikur,

Script Table from MAP_DAY?

Hi All.

Anyone can help for this.... Thank you....

Hi Eirikur,

from the script that I tell whether it could be seen where there are errors?

Thank you.

Rgds,

Gunadi

Hi Eirikur,

thanks for the quick response.

below is a script that I run :

USE [msdb]

GO

/****** Object: Job [MAP_DAY] Script Date: 11/14/2016 09:55:17 ******/

BEGIN TRANSACTION

DECLARE @ReturnCode INT

SELECT @ReturnCode...