Viewing 15 posts - 16 through 30 (of 1,577 total)
table and script trigger attached.
February 14, 2022 at 10:04 pm
Also the trigger is to add logs to another table. This is usually used when user change address from user interface web site, so it is usually one record one...
February 14, 2022 at 9:51 pm
Yes, I did check the log space, I see there is plenty space while it is running.
This is a non-production environment for me to scramble data.
So I was able to...
February 14, 2022 at 9:48 pm
That works perfectly, thanks much!
February 13, 2022 at 4:01 am
Thank you. It looks like the Modern_Spanish_CI_AS stored spanish mainly. What we want is still a database mostly stored English, but just for sometimes if users like to display their...
February 9, 2022 at 12:56 am
A second thought I do have license of Redgate of data generator as in the toolbelt bundle. Never used this tool, but maybe it can be used to replace columns'...
January 26, 2022 at 11:39 pm
For answering this question: But do you really need the whole production database in none prod? Could you get away with using a blank schema and using a data...
January 26, 2022 at 11:22 pm
Thank you both.
The product is good, but it is expensive. Not sure if we can get approval to have budget for that.
Any other recommendations?
January 26, 2022 at 6:48 pm
Yes, I totally understand the user cannot run the select query, because he doesnot have permissions on Production schema.
It is the stored procedure permissions that confused me. But Andy's answer:...
January 19, 2022 at 9:19 pm
Thanks for your recommendations. What I can say is the .exe is calling our local web application that calls vendor's web service end points. Vendor side web service is the...
August 18, 2021 at 3:28 pm
Yes, the step is execute process task that has a executable C:\_SSISFILES\Miscellaneous\eLinkUtility\Transportation.ETL.VersaTransToStaging.exe
The executable call the web service that has endpoints.
August 18, 2021 at 1:19 am
Yes, dev and test servers hitting the same end point for the services, but the web services are hosted on two web servers, one is for dev web server, the...
August 18, 2021 at 12:21 am
unfortunately it is not something simple that T-SQL can handle. There are complicated logic to calculate stop corners according to time and direction of the bus etc, that is why...
August 18, 2021 at 12:15 am
SSIS only has one execute task that calls the web service. I run today, there are 2000 routes to process, it runs about 8 hours on dev, and 10 hours...
August 17, 2021 at 11:16 pm
I did see in the .net code the route list is passed in batch to the application, but when it process detailed information in each route, it has to process...
August 17, 2021 at 10:27 pm