So, final update on this for anyone who wants to know how to properly use custom replication stored procedures.

If you're using schema_option & 0x02, it tells replication to generate default...

The mystery_proc in the above script prevents columns from being added to the replicated table. Updating it to the following solved that problem, making it a viable workaround.

            
August 23, 2024 at 11:16 am
            
#4448620

            
            
                                                
        

The tl;dr is "How do I set a custom delete replication proc for a table article?" and also "How does one use sp_register_custom_scripting?"

(This'll be my last bump, just holding thumbs...

I wouldn't be able to do the sproc modification to also write to DB2 because the latency would be too much, aside from the other issue you mentioned of...

I would like to see how many people are born on Jan 1 1900 in leaked databases 😀

I think fraud is probably the most common criminal attack, so prized PII...

Agreed. For what it's worth, I still enjoyed...

Might be worth updating the question to use NCHAR to get the character. Code written in good old ASCII won't let you down 😉

DECLARE @val NCHAR =...

Learned something new!

I knew about this one:

t = ['a', 'b', 'c']
print(*t)

The unpacking thing is cool, can put the asterisk in the middle too:

for name...

Sorry, I may...

Is it viable to check for application performance regressions by running a workload on SQL Server 2019, recording metrics, and then running the same workload on the same...

• This reply was modified 4 years, 3 months ago by  Jon 0x7f800000.

Is it viable to check for application performance regressions by running a workload on SQL Server 2019, recording metrics, and then running the same workload on the same app &...

Hi Palotaiarpad.

I think this is because the question states, "I need to code some SQL in my application", which means that it's an ad-hoc query from the application. Creating a...

Cool, thanks for confirming. You definitely achieved your goal of raising awareness of sp_prepexec() - I'll remember that one for the future 🙂

Is it not one round trip if you put both statements in the same batch? In Java I think the following is only 1 round trip:

Statement stmt...

OK, I have confirmed that there are no duplicates in the staging table at any point. So right now there is actually no reasonable explanation for the PK violation. There...