yes, the performance are better if I test small batches of updating.

sorry, the extension sql is not allowed, changed to .txt, attached

table and script trigger attached.

Thanks

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...

• This reply was modified 3 years, 7 months ago by sqlfriend.

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...

That works perfectly, thanks much!

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...

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'...

Thanks all.

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...

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?

Thanks

• This reply was modified 3 years, 7 months ago by sqlfriend.

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:...

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...

• This reply was modified 4 years, 1 month ago by sqlfriend.
• This reply was modified 4 years, 1 month ago by sqlfriend.

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.

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...

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...