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
==================================================
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
No comments:
Post a Comment