Search for hard coded words in database

Question

Search for hard coded words in database

SkyBVI

SSCoach

Points: 15128
More actions
November 12, 2010 at 9:02 am

#226625

Hi,
What is the script to search for any word 'XYZ' in the codes in all stored procs consisting in a database.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP

Viewing 10 posts - 1 through 9 (of 9 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Do a wildcard search through sys.sql_modules

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Steve Jones - SSC Editor SSC Guru Points: 736479 More actions · Answer 2

http://www.sqlservercentral.com/scripts/Stored+Procedures/65557/

Pam Brisjar SSChampion Points: 12094 More actions · Answer 3

Pam Brisjar

SSChampion

Points: 12094

November 12, 2010 at 10:49 am

#1250156

You can also use Red Gate's SQL Search tool.

Steve Jones - SSC Editor SSC Guru Points: 736479 More actions · Answer 4

Doh! Thanks, Pam

SQL Search (free): http://www.red-gate.com/products/SQL_Search/index.htm

SkyBVI SSCoach Points: 15128 More actions · Answer 5

thanks all for your replies

Regards,

Sushant

Regards
Sushant Kumar
MCTS,MCP

Pam Brisjar SSChampion Points: 12094 More actions · Answer 6

no problem. Gotta support our sponsors. Besides, I LOVE this tool. Saves a lot of headaches.

michael.francis SSC Enthusiast Points: 129 More actions · Answer 7

Hi

I work for Red Gate - could we use your kind comments on SQL Search as a testimonial please?

Regards

Michael Francis

Pam Brisjar SSChampion Points: 12094 More actions · Answer 8

Sure. It's a great tool - we use it all the time to track down issues, etc.

michael.francis SSC Enthusiast Points: 129 More actions · Answer 9

Hi

Excellent - can you drop me a line at michael.francis@red-gate.com so I can email you....

Thanks

Michael Francis