Hi,you could create a SQL Server Profiler trace to see what is different in the statement from the system. See this note 929031 - Using SQL Server Profiler for JAVA (and ABAP) - SAP for Me for details on how to do it.Best regards Clas Hortien
Hello,you can control this by creating a instead-of-trigger on the tables that the invoices are inserted into.CREATE TRIGGER (Transact-SQL) - SQL Server | Microsoft LearnUsing INSTEAD OF triggers in SQL Server for DML operations (mssqltips.com)Best r...
Hi,why you are not using the detach/attach or backup/restore method to transfer the database ? They are both much faster that the export/import method.Best regards Clas Hortien
Hi,if you have SQL Server 2017 or higher you can use the translate function from here."Returns the string provided as a first argument, after some characters specified in the second argument are translated into a destination set of characters, specif...
Hello,this can be done with the replace function like so:select replace('ML TUBE INOX 316L Ø 27X3MM""','Ø','')This has to be done for each symbol you want to replace.RegardsClas