Viewing 15 posts - 1 through 15 (of 32 total)
Hello,
Thank you all for your efforts in replying. I could trace back the issue. The flow of the stp was not proper and hence the issue.
Regards,
Saumik Vora
October 6, 2023 at 1:24 pm
Hello,
Of course the COMMIT TRAN have been put within IF and the same has been deployed already.
The question here is why in first couple of days this error did not...
October 5, 2023 at 8:52 am
Hi,
thanks for replying back. due to policies i will not be able to provide actual code but i can replicate with dummy tables. Following is the details for your ref
tblA ...
October 2, 2023 at 11:29 am
Hello,
@Jeffery and @dennis, The reason i am creating temp table with all the columns is because it will be used multiple times in the stp and all the...
October 1, 2023 at 6:10 am
Hi,
Thanks for reply. I had thought of the same of pulling the data from source. the flow will be as
Source stp calls Destination stp. This destination stp connect and pull...
February 2, 2021 at 5:41 am
Hi Erland,
We have used the profiler and included SP:StmtStarting and SP:StmtCompleted events but today will check with the error ones. However i am still looking out ways to debug the...
November 8, 2019 at 7:20 am
Hi Erland,
Thanx for the help. i figured out the issue. there was space between Param variable and the value in Param definition.
October 31, 2019 at 5:57 am
Noted about the type of the question as well as insert/edit code.
Now i passed the parameter without quotes, but still blank value is getting passed to the stp instead of...
October 30, 2019 at 1:53 pm
Hi Erland,
I followed the step as you guided. however the output did not come. On checking the profiler i found that parameter value is not getting passed. The value of...
October 30, 2019 at 1:02 pm
Hi,
Just some time back i came to know that in a single machine they are using two network cards. The setup runs properly in one card, but gives error when...
June 23, 2019 at 9:01 am
My previous answer was for Thom A.
@mark-3 Tillman yes i did change the query, but we would like to know the cause why its getting slow. also...
October 25, 2018 at 9:26 am
Hi Eddie,
Thanks for your immediate response. Just to...
September 20, 2018 at 12:06 am
March 2, 2018 at 9:38 am
Viewing 15 posts - 1 through 15 (of 32 total)