Radical plans to create a national social care service in Scotland have been abandoned in the face of widespread opposition ...