DBCON

[Former Member]

Hi gurus,

I have this requirement to insert or update the records in a table in Microsoft SQL Server. What I did is configured the DBCON and created an ABAP program that will execute native SQL commands to modify the external SQL tables.

What happens is that everytime I execute the program, a stored procedure was created in the Microsoft SQL Server. What should be causing this problem?

Your ideas will be mostly appreciated.

Thank you very much.

Andre

[Former Member · Accepted solution]

Hi Andre,

please read Note 333458 - Deleting obsolete stored procedures in SQL Server.

The section 'Reason and Prerequisites ' should answer your question.

Regards,

Sven

[Former Member · Accepted solution]

Thank you very much. Now I understand.

[Former Member · Accepted solution]

Sir another question. Is the note applicable even if my SQL Server is in another system? Meaning my SAP database is Informix and I am connectiong to a non SAP server database tables.

[clas_hortien · Accepted solution]

Hi,

the stored procedures are created from the database layer (dbmssslib.dll). So if you use this layer from your Informix system, you'll have stored procedures in your target SQL Server system.

Regards

Clas

[Former Member · Accepted solution]

Hi,

How can I stop the creation of stored procedure in the external NON SAP database?

Regards

Andre