Not had this happen before, and am at a loss to explain why to application team.
There is difference in content of the scalar function after restoration.The space between two commas in function is missing after restore.
Prod version:Microsoft SQL Server 2014(sp1) - 12.0.4100.1 (X64)
Standard Edition (64-bit) on Windows NT 6.3 (Build 9600: ) (Hypervisor)
Dev version:Microsoft SQL Server 2014(RTM) - 12.0.2000.8 (X64) Standard Edition (64-bit) on Windows NT 6.3 (Build 9600: ) (Hypervisor)
There is automatic job configured in DEV database for DEV DB refresh,which functions as below.
I dont think path level can make difference in content of the database,Kindly share your inputs on this.
--In Production server
step 1:Takes backup of PROD database to N/W path.
--In DEV server
Step 1:Copy the production backup to Dev server
step 2 :restores it on DEV database.