Search for JPG in DB tables ?

  • I have some 1500 tables in my SQLServer 2005 database. I want to search for example logo.JPG. Is it possible to write a SQL Query that can search all the tables that has logo.JPG stored?

    Thanks

  • Is the JPG stored in binary column? If so, you would first limit the search to tables that have binary columns.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

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