The situation we faced is like, one request came to restore Prod backup to Dev server with last available backup, so we have checked the last backup file history through query analyzer on prod and we have have connected the Dev through SSMS on prod, while we have to run restore on dev env. Unfortunately we have selected a new query and it was opened from prod environment and we have stared the refresh on it, so we realized after we stared. in the mean time we have contacted the application for the same and updated with the situation, but if any data might have written to the database on prod, it will be difficult to find out, we have checked the SQL server default trace to find out the details for any object got created/dropped. is there any query to find out what might have changed/inserted/updated/truncated on production during these time and apart from color coding any other suggestion on the same.
i really thank all of the member who replied on the context, i like to know more on it, please do contribute your suggestion.