NO ROWS Function ‘rs_get_textptr’ for ‘sometable’ returned no rows, table example:- create table test_tab( cola int not null, colb_txt text null) This occurs with columns containing text columns. The problem is you forgot sp_setrepcol. The default for text/image is always replicate and so not null is assumed. So you need to run sp_setrepcol to set […]
I was asked recently to setup Heterogeneous SAP replication from SAP ASE to SQL Server and then the task was extended to also replicate to an Azure Database. This can be complicated to setup and get working so I documented the procedure and updated our PDF downloadable instructions available from, http://www.dbxperts.co.uk/downloads/ A common issue with the […]