Parsing xml file

<LectureBureau RecordCount="1119">
  <Activity>
    <ActivityId>754780</ActivityId>
    <ParentActivityId />
    <ActivityTitle>NEXIUM Case Study Presentations: Patient Presenting with Symptomatic GERD</ActivityTitle>
    <ActivityTypeCode>CS</ActivityTypeCode>
    <FieldActivityCode>F</FieldActivityCode>
    <ActivityCostCenter>567255</ActivityCostCenter>
    <VenueName>Doctor's Office</VenueName>
    <VenueTypeCd>OFFICE</VenueTypeCd>
    <AddressLine1>1005 W. Market</AddressLine1>
    <AddressLine2 />
    <City>Athens</City>
    <State>AL</State>
    <Zip>35611</Zip>
    <StartDateTime>10/15/2007 12:00:00</StartDateTime>
    <EndDateTime>10/15/2007 13:00:00</EndDateTime>
    <Brand>Nexium</Brand>
    <TalkTopicESTAR>239385</TalkTopicESTAR>
    <ActivityActionCode>U</ActivityActionCode>
    <ActivityStatusCode>P</ActivityStatusCode>
    <ActivityVendorId />
    <TotalParticipantsOnSite>0</TotalParticipantsOnSite>
    <TotalParticipantsRemote>0</TotalParticipantsRemote>
    <TotalSpeakersOnSite>0</TotalSpeakersOnSite>
    <TotalSpeakersRemote>0</TotalSpeakersRemote>
    <TotalModeratorsOnSite>0</TotalModeratorsOnSite>
    <TotalModeratorsRemote>0</TotalModeratorsRemote>
    <TotalCustomersOnSite>0</TotalCustomersOnSite>
    <TotalCustomersRemote>0</TotalCustomersRemote>
    <TotalEmployeesOnSite>0</TotalEmployeesOnSite>
    <TotalEmployeesRemote>0</TotalEmployeesRemote>
    <ProgramSubmitDateTime>07/16/2007 08:51:18</ProgramSubmitDateTime>
    <ProratedPaymentFlg>N</ProratedPaymentFlg>
    <ProgramPaymentOverrideFlg>N</ProgramPaymentOverrideFlg>
    <ActivityCost>
      <CostTypeCode>CORE</CostTypeCode>
      <CostAmount>235.00</CostAmount>
      <GLCode />
    </ActivityCost>
    <ActivitySponsor>
      <SponsorTypeCode>HOST</SponsorTypeCode>
      <SponsorName>Jerre Glover</SponsorName>
      <SponsorTerritory>CCANABAE</SponsorTerritory>
      <SponsorEmployeeId>40059884</SponsorEmployeeId>
    </ActivitySponsor>
    <ActivitySponsor>
      <SponsorTypeCode>APPV</SponsorTypeCode>
      <SponsorName>John A. Howard</SponsorName>
      <SponsorTerritory />
      <SponsorEmployeeId>40016978</SponsorEmployeeId>
    </ActivitySponsor>
    <ActivitySponsor>
      <SponsorTypeCode>RQST</SponsorTypeCode>
      <SponsorName>Jerre Glover</SponsorName>
      <SponsorTerritory>CCANABAE</SponsorTerritory>
      <SponsorEmployeeId>40059884</SponsorEmployeeId>
    </ActivitySponsor>
    <ActivitySponsor>
      <SponsorTypeCode>PEDN</SponsorTypeCode>
      <SponsorName>Jose Duprey</SponsorName>
      <SponsorTerritory />
      <SponsorEmployeeId />
    </ActivitySponsor>
    <Attendee>
      <AttendeeType>S</AttendeeType>
      <AttendeeCompassId>308478889</AttendeeCompassId>
      <AttendeeVPId>514527</AttendeeVPId>
      <AttendeeEmployeeId />
      <AttendanceType>I</AttendanceType>
      <AttendeeFirstName>Khurshid</AttendeeFirstName>
      <AttendeeMiddleName />
      <AttendeeLastName>Yousuf</AttendeeLastName>
      <AttendeeAddrLine1>1103 15th Avenue South East</AttendeeAddrLine1>
      <AttendeeAddrLine2 />
      <AttendeeCity>Decatur</AttendeeCity>
      <AttendeeState>AL</AttendeeState>
      <AttendeeZip>35601</AttendeeZip>
      <AttendeeSSN>105-78-4475</AttendeeSSN>
      <AttendeeClassification />
      <AttendeeClassificationExplain />
      <AttendeeOnSite>N</AttendeeOnSite>
      <AttendeeEmail>gidoc2r@hotmail.com</AttendeeEmail>
      <AttendeeExpense>
        <ExpenseTypeCode>COMP</ExpenseTypeCode>
        <ExpensePayeeName>Khurshid Yousuf</ExpensePayeeName>
        <ExpensePayeeSSNTaxId>105-78-4475</ExpensePayeeSSNTaxId>
        <ExpenseAmount>750.00</ExpenseAmount>
        <GLCode>6451050</GLCode>
      </AttendeeExpense>
    </Attendee>
  </Activity>
  <Activity>

My xml file looks like this with over 1000 activity id's...I want to just get the activity id's for the meetings in this file QUICKLY.  I have SQL Server 2000, .netStart Free Trial