I have always liked to code applications that automatically scan for information in Oracle database (See Oracle PL/SQL Data Scanner Script at http://ntic974.blogspot.fr/2011/09/oracle-plsql-data-scanner-script-v02.html) so I have quickly coded this application that searches for a specific string in all user tables in a SQL Server environment.
Enter your connection string in the APP.CONFIG file, then launch the application. It asks you for a valueto search, then search for the entered value in all user tables and columns.
A powerful and simple scanner that automatically detects user tables and columns, and scans them for a specific value...
Coded in C# so feel free to adapt it to fit your needs. Please just mention "Reunisoft" or "DVA Software" in your versions.
Be the first to post a review of SQL Server Data Scanner!