Data Base records have bad data in them

  • I have SQL 2014 on two Windows 2012 R2 Servers using Clustering.  all working ok.
    I have a web site and someone added garbage on my records.

    Select Songs you Wish to Add to Your Playlist then click on Submit button

    internet drug coupons open coupons for cialis

    "> Led Zeppelin BBC Sessions You Shook Me M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\1-01-BBC Sessions-You Shook Me.mp3

    internet drug coupons open coupons for cialis

    Led Zeppelin BBC Sessions I Cant Quit You Baby M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\1-02-BBC Sessions-I Cant Quit You Baby.mp3

    sumatriptan migraine headache http://sumatriptannow.com/migraine-headache sumatriptan migraine headache
    bystolic patient assistance open does bystolic have a generic

    "> Led Zeppelin BBC Sessions Communication Breakdown M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\1-03-BBC Sessions-Communication Breakdown.mp3

    sumatriptan migraine headache http://sumatriptannow.com/migraine-headache sumatriptan migraine headache
    bystolic patient assistance open does bystolic have a generic

    gabapentin icd 9 gabapentin icd 9 gabapentin icd 9
    bystolic patient assistance open does bystolic have a generic

    "> Led Zeppelin BBC Sessions Dazed and Confused M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\1-04-BBC Sessions-Dazed and Confused.mp3

    gabapentin icd 9 gabapentin icd 9 gabapentin icd 9
    bystolic patient assistance open does bystolic have a generic

    Led Zeppelin BBC Sessions The Girl I Love She Got Long Black Wavy Hair M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\1-05-BBC Sessions-The Girl I Love She Got Long Black Wavy Hair.mp3

    Led Zeppelin BBC Sessions What Is and What Should Never Be M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\1-06-BBC Sessions-What Is and What Should Never Be.mp3

    Led Zeppelin BBC Sessions Communication Breakdown M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\1-07-BBC Sessions-Communication Breakdown.mp3

    Led Zeppelin BBC Sessions Travelling Riverside Blues M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\1-08-BBC Sessions-Travelling Riverside Blues.mp3

    Led Zeppelin BBC Sessions Whole Lotta Love M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\1-09-BBC Sessions-Whole Lotta Love.mp3

    home abortion remedies saiftec.com abortion papers

    "> Led Zeppelin BBC Sessions Somethin Else M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\1-10-BBC Sessions-Somethin Else.mp3

    home abortion remedies saiftec.com abortion papers

    abortion pill abortion pill abortion pill

    "> Led Zeppelin BBC Sessions Communication Breakdown M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\1-11-BBC Sessions-Communication Breakdown.mp3

    abortion pill abortion pill abortion pill

    cialis coupon cialis coupon cialis coupon
    abortion pill abortion pill abortion pill

    "> Led Zeppelin BBC Sessions I Cant Quit You Baby M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\1-12-BBC Sessions-I Cant Quit You Baby.mp3

    cialis coupon cialis coupon cialis coupon
    abortion pill abortion pill abortion pill

    Led Zeppelin BBC Sessions You Shook Me M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\1-13-BBC Sessions-You Shook Me.mp3

    cialis coupon cialis coupon cialis coupon

    "> Led Zeppelin BBC Sessions How Many More Times M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\1-14-BBC Sessions-How Many More Times.mp3

    cialis coupon cialis coupon cialis coupon

    sumatriptan migraine headache sumatriptan migraine headache sumatriptan migraine headache

    "> Led Zeppelin BBC Sessions Immigrant Song M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\2-01-BBC Sessions-Immigrant Song.mp3

    sumatriptan migraine headache sumatriptan migraine headache sumatriptan migraine headache

    internet drug coupons coupons for cialis

    "> Led Zeppelin BBC Sessions Heartbreaker M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\2-02-BBC Sessions-Heartbreaker.mp3

    internet drug coupons coupons for cialis

    Led Zeppelin BBC Sessions Since Ive Been Loving You [#] M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\2-03-BBC Sessions-Since Ive Been Loving You [#].mp3

    sumatriptan migraine headache sumatriptan migraine headache sumatriptan migraine headache
    bystolic patient assistance read does bystolic have a generic

    "> Led Zeppelin BBC Sessions Black Dog [#] M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\2-04-BBC Sessions-Black Dog [#].mp3

    sumatriptan migraine headache sumatriptan migraine headache sumatriptan migraine headache
    bystolic patient assistance read does bystolic have a generic

    cialis coupon cialis coupon cialis coupon
    sumatriptan migraine headache http://sumatriptannow.com/migraine-headache sumatriptan migraine headache

    "> Led Zeppelin BBC Sessions Dazed and Confused M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\2-05-BBC Sessions-Dazed and Confused.mp3

    cialis coupon cialis coupon cialis coupon
    sumatriptan migraine headache http://sumatriptannow.com/migraine-headache sumatriptan migraine headache

    free prescription drug discount card cialis manufacturer coupon new prescription coupons
    sumatriptan migraine headache http://sumatriptannow.com/migraine-headache sumatriptan migraine headache

    "> Led Zeppelin BBC Sessions Stairway to Heaven M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\2-06-BBC Sessions-Stairway to Heaven.mp3

    free prescription drug discount card cialis manufacturer coupon new prescription coupons
    sumatriptan migraine headache http://sumatriptannow.com/migraine-headache sumatriptan migraine headache

    Led Zeppelin BBC Sessions Going to California M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\2-07-BBC Sessions-Going to California.mp3

    cialis coupon cialis coupon cialis coupon
    sumatriptan migraine headache http://sumatriptannow.com/migraine-headache sumatriptan migraine headache

    "> Led Zeppelin BBC Sessions Thats the Way M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\2-08-BBC Sessions-Thats the Way.mp3

    cialis coupon cialis coupon cialis coupon
    sumatriptan migraine headache http://sumatriptannow.com/migraine-headache sumatriptan migraine headache

    gabapentin icd 9 gabapentin icd 9 gabapentin icd 9

    "> Led Zeppelin BBC Sessions Whole Lotta Love MedleyBoogie Chillun-Fixin to Die-Thats M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\2-09-BBC Sessions-Whole Lotta Love Medley- Boogie Chillun-Fixin to Die-Thats.mp3

    gabapentin icd 9 gabapentin icd 9 gabapentin icd 9

    free prescription drug discount card outbackuav.com new prescription coupons
    internet drug coupons open coupons for cialis

    "> Led Zeppelin BBC Sessions Thank You [#] M:\Music\MP3MusicAlbums\Led Zeppelin\BBC Sessions\2-10-BBC Sessions-Thank You [#].mp3

    free prescription drug discount card outbackuav.com new prescription coupons
    internet drug coupons open coupons for cialis

      

    As you can see the ads added to the records.

    From the database I expanded tables and reviewed the dbo,recordings went thu the record and did not find any thing displayed I did a search and it pointed to a record but the record looks good.

    In the past I run this command to clear them all

    updatedbo.recordings set RecordingTitle = left(RecordingTitle, CHARINDEX('<',RecordingTitle)-1)

    WHERECHARINDEX('<', RecordingTitle ) > 0

    how do I clean this up 

    Thank you

    Tom

  • Maybe it is not your database but your web/app frontend that got hacked?
    Your website might execute an addional javascript to provide the tampered content or reroute requests?

  • Thanks for responding.

    I have reviewed all my code on the site do not see any additional code that would do this.

    It is in the database I am sure of that but can not find the records.

    Has to be a way to dump the records ?????

    Thank you,

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply