thank you for your answer

i just tested it again and i don't have the problem anymore
i think there are two possible reasons why i had the problem yesterday:
- it was a problem of too less memory, because i use a "local temporary
table" in the SP:
CREATE TABLE #BulkLoadTable
(
....
)

- it was because i use this code for insertion:
EXEC sp_ExecuteSQL 'BULK INSERT #BulkLoadTable FROM ...'



here is the complete code of the SP:



---------- CODE ----------
CREATE PROCEDURE [dbo].[CRM_BulkLoadEMail]
@i_iCampaignExtensionId integer,
@i_iEntryType integer,
@i_vchLoadFile nvarchar(255),
@i_vchRowTerminator nvarchar(50),
@i_vchFieldTerminator nvarchar(50),
@i_tiGetParameterLength tinyint,
@o_iLoadedRows integer OUTPUT,
@i_dtQueueTime datetime = Null
AS
/*
** ObjectName: CRM_BulkLoadEMail
**
** Description: This stored procedure performs a bulk insert for an
email
** outbound operation.
*/

BEGIN
DECLARE @iReturnCode integer,
@iError integer

DECLARE @vchBatchSize nvarchar(15)
DECLARE @vchSQLBulkInsert nvarchar(4000)
DECLARE @chC4EntityType char(1)
Declare @iPermissionCode integer
Declare @iResponseYes integer
Declare @iSubSurveyId integer

SET NOCOUNT ON

SET @iReturnCode = 0

-- try to get the BatchSize (Commit Frequency for the Bulk Insert)
SELECT
@vchBatchSize = itemValue
FROM
CRMConfig
WHERE
serviceName = 'CRMFeeder' AND
moduleName = 'OutboundEMail' AND
itemName = 'BatchSize' AND
itemIdx = 0

-- try to get the PermissionCode
Select
@iPermissionCode = CAST( vchParameter As integer )
From
CRMCampaign_CampaignExtensionParameter
Where
iCampaignExtensionId = @i_iCampaignExtensionId And
vchParameterDesc = 'PermissionCode'

-- try to get the Yes Response Id
Select
@iResponseYes = CAST( itemValue As integer )
From
CRMConfig
Where
serviceName = 'PermissionMarketing' And
moduleName = 'SurveyHandling' And
itemName = 'Yes ResponseId' And
itemIdx = 0

-- try to get the Subscription Survey Id for Permissions
Select
@iSubSurveyId = CAST( itemValue As integer )
From
CRMConfig
Where
serviceName = 'PermissionMarketing' And
moduleName = 'SurveyHandling' And
itemName = 'SubscriptionSurvey_Id' And
itemIdx = 0

-- create a private temp table, this is necessary to be avoid
conflicts
-- if more than one load operation is performed concurrently.
CREATE TABLE #BulkLoadTable
(
entryId integer PRIMARY KEY,
msisdn varchar(255),
PARA0 varchar(255),
PARA1 varchar(255),
PARA2 varchar(255),
PARA3 varchar(255),
PARA4 varchar(255),
PARA5 varchar(255),
PARA6 varchar(255),
PARA7 varchar(255),
PARA8 varchar(255),
PARA9 varchar(255),
PARA10 varchar(255),
PARA11 varchar(255),
PARA12 varchar(255),
PARA13 varchar(255),
PARA14 varchar(255),
PARA15 varchar(255),
PARA16 varchar(255),
PARA17 varchar(255),
PARA18 varchar(255),
PARA19 varchar(255)
)

-- create an index for checking the email address (column msisdn)
-- for CR and LF
CREATE NONCLUSTERED INDEX BulkLoadTable_MSISDN ON #BulkLoadTable
( msisdn )

-- fill the private temp Bulk load table
SET @vchSQLBulkInsert = 'BULK INSERT #BulkLoadTable FROM ''' +
@i_vchLoadFile + ''' WITH ( ROWTERMINATOR = ''' + @i_vchRowTerminator +
''', FIELDTERMINATOR = ''' + @i_vchFieldTerminator + ''', KEEPNULLS,
CODEPAGE = ''ACP'''
If NOT @vchBatchSize IS NULL
begin
SET @vchSQLBulkInsert = @vchSQLBulkInsert + ', BATCHSIZE = ' +
@vchBatchSize + ' )'
end
else
begin
SET @vchSQLBulkInsert = @vchSQLBulkInsert + ' )'
end

EXEC sp_ExecuteSQL @vchSQLBulkInsert

-- remove all entries where CRs or LFs are found in the email address
-- (msisdn column), because this entries wont be processed correct
DELETE FROM
#BulkLoadTable
WHERE
msisdn LIKE '%' + CHAR(10) + '%' OR
msisdn LIKE '%' + CHAR(13) + '%'

-- retrieve entry-type
declare @vchParameterDesc nvarchar(50)
select @vchParameterDesc = vchParameterDesc
from referencedefinition
where
iparameterid = @i_iEntryType
and tirecordstatus = 1

-- set the C4EntityType
if @vchParameterDesc = 'C4 Account Id'
begin
SET @chC4EntityType = 'A'
end -- else if @vchParameterDesc = 'C4 Account Id'
else if @vchParameterDesc = 'C4 Customer Id'
begin
SET @chC4EntityType = 'C'
end -- else if @vchParameterDesc = 'C4 Customer Id'
else if @vchParameterDesc = 'C4 Subscriber Id'
begin
SET @chC4EntityType = 'S'
end -- else if @vchParameterDesc = 'C4 Subscriber Id'
else
begin
SET @chC4EntityType = 'O'
end -- if @vchParameterDesc = 'C4 Account Id'

-- generate the LoaderQueue entries for the loaded email items
-- check if the queue time is got
If @i_dtQueueTime Is Null
Begin
Set @i_dtQueueTime = GetDate()
End -- If @i_dtQueueTime Is Null

-- determine if the PermissionCode is to be used or not
If IsNull( @iPermissionCode, 0 ) = 0
Begin
-- no Permission Code is used
-- join to onyx-tables to avoid load of unknown entries
INSERT INTO CRMCampaign_LoaderQueue
( iCampaignExtensionId,
iEntryType,
entryId,
msisdn,
statusCode,
queueTime,
lastChanged )
SELECT
@i_iCampaignExtensionId as iCampaignExtensionId,
@i_iEntryType AS iEntryType,
entryId,
CAST( msisdn AS varchar(50) ) AS 'msisdn',
'D' as statusCode,
@i_dtQueueTime AS 'queueTime',
GetDate() AS lastChanged
FROM
#BulkLoadTable blt
JOIN
(
SELECT iCompanyId AS iOwnerId FROM Company WHERE tiRecordStatus <>
0
UNION
SELECT iIndividualId AS iOwnerId FROM Individual WHERE
tiRecordStatus <> 0
) Owner ON (Owner.iOwnerid = dbo.CRM_GetOnyxIdFromC4Id(
@chC4EntityType, blt.EntryId ) )
End -- If IsNull( @iPermissionCode, 0 ) = 0
Else
Begin
-- Permission Code is used, this means extra joins to survey system
-- join to onyx-tables to avoid load of unknown entries
INSERT INTO CRMCampaign_LoaderQueue
( iCampaignExtensionId,
iEntryType,
entryId,
msisdn,
statusCode,
queueTime,
lastChanged )
SELECT
@i_iCampaignExtensionId as iCampaignExtensionId,
@i_iEntryType AS iEntryType,
entryId,
CAST( msisdn AS varchar(50) ) AS 'msisdn',
'D' as statusCode,
@i_dtQueueTime AS 'queueTime',
GetDate() AS lastChanged
FROM
#BulkLoadTable blt
JOIN
(
SELECT iCompanyId AS iOwnerId FROM Company WHERE tiRecordStatus <>
0
UNION
SELECT iIndividualId AS iOwnerId FROM Individual WHERE
tiRecordStatus <> 0
) Owner ON (Owner.iOwnerid = dbo.CRM_GetOnyxIdFromC4Id(
@chC4EntityType, blt.EntryId ) )
JOIN CustomerProfile CP WITH ( NoLock, Index(
NNXCustomerProfile_ownerid ) ) ON
CP.iOwnerId = Owner.iOwnerId And