I'll study the second post, but to the first post - ignore my verbage about logs... it's not really a log... my transaction table gets records generated directly from purchases,...

I'm wanting the trigger to create a record and take the next number in the table's sequence.

Here's my DDL for my table:

USE [TrackIT]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tblTransactions](

[PO_Number] [varchar](50) NULL,

[Buyer_Initial] [varchar](50) NULL,

[Quantity] [int] NULL,

[Unit_Price] [money] NULL,

[Software_Description] [varchar](100) NULL,

[AllocationAccount] [varchar](50) NULL,

[PurchaseAccount] [varchar](50) NULL,

[HeatTicketNumber] [varchar](50)...

Here is my DDL for the two tables so looks like I need to do some cleanup:

CREATE TABLE [dbo].[Master](

[Buyer_Initial] [varchar](50) NULL,

[HeatTicketNumber] [varchar](50) NULL,

[PO_Number] [varchar](50) NULL,

[Transaction_Date] [date] NULL,

[EndUserLastName] [varchar](100) NULL,

[EndUserFirstName] [varchar](100)...

tried these variations to make sure syntax wasn't biting me:

USE [TrackIT]

GO

set identity_insert tblTransactions ON

GO

INSERT INTO [dbo].[tblTransactions]

(tblTransactions.Buyer_Initial,

USE [TrackIT]

GO

set identity_insert tblTransactions ON;

GO

INSERT INTO [dbo].[tblTransactions]

(tblTransactions.Buyer_Initial,

USE [TrackIT]

Set identity_insert tblTransactions ON;

GO

INSERT INTO [dbo].[tblTransactions]

(tblTransactions.Buyer_Initial,

USE [TrackIT]

GO

set identity_insert...

SET IDENTITY_INSERT [TrackIT].[dbo].[tblTransactions] ON worked as far as:

"Command(s) completed successfully."

But When I try to run my INSERT I get:

"Msg 544, Level 16, State 1, Line 1

Cannot insert explicit value for...

table exists and I routinely run commands like this which would indicate I have permissions (?):

ALTER TABLE dbo.tblTransactions

ADD TransferFrom VARCHAR(100) Null;

GO

I can go with changing the first part to "SELECT LTRIM(SubString(CustomerName,-1" and that does the trick in this case

I've only found 5 out of 8,000 records which I simply hand scrubbed... all else were in stated format

Yes correct schema... fully qualified is TrackIT dbo tblTransactions... and I'm in the correct database in which I can run queries, add fields, query my data, redefine datatypes, write triggers,...

Tried loading my data and got the same error.

Then tried SET IDENTITY_INSERT dbo.tblTransactions ON again and it said: Cannot find the object "dbo.tblTransactions" because it does not exist or...

SET IDENTITY_INSERT dbo.tblTransactions ON - that worked... thanks!

tried and get: Msg 1088, Level 16, State 11, Line 1

Cannot find the object "tblTransactions" because it does not exist or you do not have permissions.

One additional question... my receiving table has its primary key with "Is Identity" being "Yes" and and a seed of 18000 incremented by one... the number of records (historical data)...

Thanks... worked!