Thank you for your post into the forum.
When using the shared db model you increase the chance of conflicts in the manner that you have described.
SQL Source Control supports both methods, dedicated and shared but we (Red Gate) recommend the dedicated model as this greatly reduces the known problems using the shared model.
This Knowledge Base article
explains the Database Development Models.
I hope this helps to answer your questions.
This second knowledge base article explains Conflict resolution.