question

I will try to explain what I am trying to do. I have a line, polygon, what ever you want to call it. Let's say a straight sidewalk that is 1000 feet long. I have a group of points (Lat/Longs). I create a round buffer around each point that is say 10 meters. I want to know what part of my sidewalk each of these individual points comes into contact with. So, for example if only one point comes into contact with my sidewalk and 10 feet of the sidewalk is in the buffer zone I want to know what 10 feet it is? Is this possible with TSQL. I've seen this done visually. Basically, I want to be able to show what part of the sidewalk was inspected. The inspector would be carrying a GPS device (such as a Garmin) that would be capturing the inspector current location every 15 seconds. Please let me know if you have any question.