I can't get my temp tables to work today and no-one in my team has a clue either! I have a main SProc which is creating the temp tables which I can then select from in the same SProc (so they are definitely there). I need to use them in another SProc called from the one that created the temp tables (EXEC @status_val=tc_stg_backdated_evts @debug=@debug) and it tells me that the temp tables don't exist. I can select from the main SProc again directly after calling the sub Sproc so what's going on? Happy to provide all SQL if that helps.
I see, that you are creating your tables in tc_stg_backdated_evts again in case when @trancount is zero - probably to make it work even when it's not invoked from tc_unstaging. I'm not sure, if it's possibe
MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
The Nano Server Image Builder helps you create a custom Nano Server image and bootable USB media with the aid of a graphical interface. Based on the inputs you provide, it generates images for deployment and creates reusable PowerShell scripts that …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online.
The email signature template has been downloaded from: