When i try to specify the length of charcter that is more then 8000 characters (only then) i get an error message that says.

"Microsoft OLE DB Provider for SQL Server

Code...

Thank you for your answer.

There is no problem creating the stored procedure, the problem is calling it from asp page like this:

************Start Code*******************

Function ExecuteSP(sXmlString)

Dim ObjCmdExecuteSP

Set ObjCmdExecuteSP = Server.CreateObject("ADODB.Command")

With ObjCmdExecuteSP

.ActiveConnection =...