<div>
in order to search for a keyword, after running the above &nbsp;(Please replace 'Alter procedure' with 'CREATE PROCEDURE' &nbsp;) &nbsp;you have run this on a new query window <br />
<br />
exec &nbsp;SearchAllTables &nbsp;'keywordToSearch' <br />
<br />

</div>


in order to search for a keyword, after running the above  (Please replace 'Alter procedure' with 'CREATE PROCEDURE'  )  you have run this on a new query window

exec  SearchAllTables  'keywordToSearch'



<div>
<div class="content wysiwyg-content">
Hi,<br />
I have lost the password to an application that it's database resides on SQL. I was wondering if I can look for the username and password in 1 of the tables in the SQL and then change the password. <br />
<br />
My proble is that i have more thab 300 tables in the database. is there a way to search all columns of all tables in a database for a keyword?
</div>
</div>


Hi,
I have lost the password to an application that it's database resides on SQL. I was wondering if I can look for the username and password in 1 of the tables in the SQL and then change the password. 

My proble is that i have more thab 300 tables in the database. is there a way to search all columns of all tables in a database for a keyword?

How to search all columns of all tables in a database for a keyword

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.