SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: July 2011

Brute-force searching for data.

Today, I needed a way of searching through a database, any database, looking for a certain string. The procedure I had was an old one that used the information_schema and I couldn't figure out how to update it to take in user-types, so I wrote one using system views. It… Read more

7 comments, 3,091 reads

Posted in Phil Factor's Phrenetic Phoughts: The SQL on 8 July 2011