Hi,

No triggers on table. I am doing the direct insert in stored procedure. Here is the code. What do you think about the table structure? Is it good enough?

[usp_Insert]

(

@SiteId astinyint = 1,

@ReferenceId as tinyint,

@CallId as int,

@ResultingCallId as int,

@SourceIP as char (15),

@DestinationIPas char (15),

@ProtocolId astinyint,

@ApplicationId as int,

@OperationValue asvarchar (50),

@SpecificEvent as varchar (50),

@DNIS as int,

@ANI as varchar (20),

@CallingNumber as varchar (20),

@CallingAddressType as varchar(20),

@CalledNumber as varchar (20),

@CalledAddressType as varchar(20),

@DomainExtension as int,

@Count as tinyint,

@OriginationPort as smallint,

@ConnectedNumber as varchar (20),

@ConnectedNumber2 as varchar (20),

@ConnectedAddressType as varchar (20),

@TrunkGroup assmallint,

@TrunkMember as smallint,

@Causeas varchar (50),

@DateReceived as datetime,

@TimeZoneOffset assmallint

)

AS

BEGIN

INSERT INTO [TT_TSAPIDataA]

([SiteId]

,[ReferenceId]

,[CallId]

,[ResultingCallId]

,[SourceIP]

,[DestinationIP]

,[ProtocolId]

,[ApplicationId]

,[OperationValue]

,[SpecificEvent]

,[DNIS]

,[ANI]

,[CallingNumber]

,[CallingAddressType]

,[CalledNumber]

,[CalledAddressType]

,[DomainExtension]

,[Count]

,[OriginationPort]

,[ConnectedNumber]

,[ConnectedNumber2]

,[ConnectedAddressType]

,[TrunkGroup]

,[TrunkMember]

,[Cause]

,[DateReceived]

,[TimeZoneOffset])

VALUES

(@SiteId1,

@ReferenceId1,

@CallId1,

@ResultingCallId1,

@SourceIP1,

@DestinationIP1,

@ProtocolId1,

@ApplicationId1,

@OperationValue1,

@SpecificEvent1,

@DNIS1,

@ANI1,

@CallingNumber1,

@CallingAddressType1,

@CalledNumber1,

@CalledAddressType1,

@DomainExtension1,

@Count1,

@OriginationPort1,

@ConnectedNumber1,

@ConnectedNumber21,

@ConnectedAddressType1,

@TrunkGroup1,

@TrunkMember1,

@Cause1,

DATEADD(mi,@TimeZone,@DateReceived1), --@DateReceived

@TimeZone)

)