I have been using backup -- one file per object Today i was inspecting my backup and it happens that my Tables have the same name of my stored procedures and thus i have data missing. Renaming all he procedures is not an option, i have a lot and they are called from stored procedures. Is there a possibility to add a prefix for every backup indicating the type to prevent this kind of error ? ie table_Mytable_whatever.sql prcedure_Mytable_whatever.sql trigger_Mytable_whatever.sql I think it should be easy to accomplsh and would prevent the problem. Thank you.
