Monday, April 2, 2012

Sub Account Day End Error - Solution

If you face an error in Sub Account as ' Invalid Object name sotransit020412' then run following script in Query Analyser. Problem will be solved :

==================================================
USE [supplysubaccounts]
GO
/****** Object:  Table [dbo].[sotransit020412]    Script Date: 02/04/12  15:12:11 V. D. Vadher ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sotransit020412](
    [fromso] [char](3) NULL,
    [toso] [char](3) NULL,
    [remittancedate] [datetime] NULL,
    [sentorreceived] [char](1) NULL,
    [amount] [numeric](15, 2) NULL,
    [adjusted] [bit] NULL,
    [dummycolumn] [timestamp] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sotransit020412]    Script Date: 02/04/12  15:12:11 V. D. Vadher ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
USE [bosupplysubaccounts]
CREATE TABLE [dbo].[sotransit020412](
    [fromso] [char](3) NULL,
    [toso] [char](3) NULL,
    [remittancedate] [datetime] NULL,
    [sentorreceived] [char](1) NULL,
    [amount] [numeric](15, 2) NULL,
    [adjusted] [bit] NULL,
    [dummycolumn] [timestamp] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF