My approach when things like this happen is I start my DR (disaster recovery) process. Restore the last known good backup to a test system and then copy the data...

I would start by checking the logs on the publisher and subscriber as those will tell you what is wrong. Likely a permission issue on either the publisher or subscriber,...

It sounds like you have a tool that monitors memory usage on the server. If you want a per-process app that'll do that, perfmon or task manager will monitor your...

Are you meaning per query or overall? and what do you mean by "continuously"? Like you want a realtime constant monitoring of overall memory usage? If so, then the easiest...

Welcome to the dev world then! When I was new to SQL, one of the hardest things I had to wrap my brain around was "row based operations" vs "column...

As a guess, if you select "Insert Row", it should have an option to add it at the top or bottom (if I remember right)... after adding a row, are...

VERY quick look at that, you have a bunch of dynamic SQL which is always a bit risky, so my opinion, I would re-write the whole thing without the dynamic...

VERY quick look at that, you have a bunch of dynamic SQL which is always a bit risky, so my opinion, I would re-write the whole thing without the dynamic...

First step, review the execution plan. Next step, I'd check server resources and server settings. If the query is slower, is the hardware identical? If not, that could be the...

slow inserts are USUALLY caused by either slow network connection between the client machine and the database OR poor indexing strategy on the table OR stored procedure for the insert...

My opinion, I'd redesign the original table to not allow varchar in the column and force ints... but if you are stuck with that, I would look at a string...

the rows affected can be removed by running the command "SET NOCOUNT ON" at the start of the SP.

As for the date/time issue, that is Excel taking the date and...

My only thought there is that your bat/ps1 file is not 100% identical to your command. To me it sounds like the bat file or ps1 file is not running...

I'm not sure what you mean by "moving onto the next table" but looking at your script, I suspect that your script is running and never ending, right? Your while...

I can only think of 2 reasons for this. First is permissions - are you using the same account to run the bat/ps1 file or are you changing accounts and...