October 8, 2017 at 4:00 pm
Hello
We have sql Database which is fetching modified records from a linked server of another team. There is a stored procedure and this sp is being executed from a front end application and it will update our records if there is any changes on daily basis. These are Human resource records including employee details and photo.
But we noticed lately that some records were not updating in our system and now i would like to know if there is any criteria in sql server for such task.. How the insertion or update works . ? how to find out the data is meeting the standard ?
long before we noticed the images were out of size and this caused updating our system but it was resolved at that time.
I hope the question is clear and will update if necessary for futher clarification
Regards
October 9, 2017 at 3:16 am
Can you provide some more details:
What do you mean by 'sp is being executed from a front end application'?
Is the sp running on schedule or is it triggered by any event/action?
What is the code in sp actually doing? IS it possible to share sp code?
Are data types in both tables in Sync?
October 9, 2017 at 3:23 am
We are missing a lot of information here. We don't have any details on what your DDL looks like at either end, or what the query being used is to update the data at one end.
Ideally, we'd need DDL for both tables, and the SQL statement that you run. Even better, some DLM as well. Then we need to know what type of records aren't going across (a consumable example record for your DDL would be best). At a guess, I would imagine that you're checking the columns for differences, and the column being changed isn't in your checks; thus isn't replicated.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply