Hi, Could you send exact error you are getting as SQL statment looks good. ~ Vikrant

That's not necessary, It looks like variable value is not going throguh, Could you attach your application, It looks mismtach over there. ~Vikrant

Ya I got bundle, Let me try that, Will update you on same ~ Vikrant

Quoting rajivlcr ...
INSERT INTO XXX_TRACE VALUES('15244194326c8255fcdcc5334611','','',GetUserName.body/ldap:batchResponse/ldap:searchResponse/ldap:searchResultEntry/@dn)

But its giving me SYntax error.

Do i miss quotes here? How to form valid statement?

I have tried using single quotes. But no use.

Could you provide some details for the table 'XXX_TRACE'?

The table was created in your database with some 'CREATE TABLE ...' SQL-statement. So, it would be nice to see
thatSQL-statement ( types for these 4columns, ALL constraints,etc ).

Best regards,
Sergey

Please use the following SQL-script to reproduce the error:

USE master
GO
IF EXISTS ( SELECT * FROM master..sysdatabases WHERE name='TestDb' )
DROP DATABASE TestDb
GO
PRINT 'TestDb database is deleted successfully'
GO

SET TRANSACTION ISOLATION LEVEL read uncommitted
GO
SET NOCOUNT OFF
GO

CREATE DATABASE TestDb
GO
USE TestDb
GO
PRINT 'TestDb database is created successfully'
GO

CREATE TABLE TestTable
(
TTID INT IDENTITY (1,1) NOT NULL,
TTFIELD1 VARCHAR NULL,
TTFIELD2 VARCHAR(24) NULL,
TTFIELD3 CHAR(24) NULL
)
GO

--SELECT * FROM TestTable

--BEGIN TRANSACTION

-- Test1 - No Error: (1 row(s) affected)
INSERT INTO TestTable
( TTFIELD1, TTFIELD2, TTFIELD3 )
VALUES
( '0', '012345678901234567890123', '012345678901234567890123' )

-- Test2 - Error:
-- Server: Msg 8152, Level 16, State 14, Line 2
-- String or binary data would be truncated.
-- The statement has been terminated.
INSERT INTO TestTable
( TTFIELD1, TTFIELD2, TTFIELD3 )
VALUES
( '01', '012345678901234567890123', '012345678901234567890123' )

-- Test3 - Error:
-- Server: Msg 8152, Level 16, State 14, Line 2
-- String or binary data would be truncated.
-- The statement has been terminated.
INSERT INTO TestTable
( TTFIELD1, TTFIELD2, TTFIELD3 )
VALUES
( '0', '0123456789012345678901234', '012345678901234567890123' )

-- Test4 - Error:
-- Server: Msg 8152, Level 16, State 14, Line 2
-- String or binary data would be truncated.
-- The statement has been terminated.
INSERT INTO TestTable
( TTFIELD1, TTFIELD2, TTFIELD3 )
VALUES
( '0', '012345678901234567890123', '0123456789012345678901234' )

--COMMIT
--ROLLBACK

I have tried using single quotes. But no use.

Hi everybody,
This is a follow up: Are there any news / updates?
Best regards,
Sergey