Networks

Ask something
Question Locked

Find hard coded strings in SQL: can it be done programatically?

0 helpful
4 replies

by locrian_lyric

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

The problem:

Company was bought out and we are bringing everything into complience. Passwords are not secure and do not need to be.(required by software we are using)

Old passwords *may or may not have been hard coded* in SQL SERVER database to validate (each account was setup with the same generic password).

Need to check each proc or function for presense of hard-coded password.

We have hundreds of functions that may or may not have this hard coded password.

Is there a way to cycle through each proc and function to search for the presence of the password, either through SQL or an app to hit SQL server?

4 replies

by tony hopkinson

But probably the easiest way is just to script the database schema to file and them parse through it in text.

This discussion is closed to new replies.