To search all the tables

• SQLTestUser

  Hall of Fame

  Points: 3997

  More actions

  August 11, 2010 at 11:16 am

  #222423

  I am looking for a script that i can provide to a user so that he can search for a string the word "alert" in the entire database ( i.e all the tables)

  Please let me know if there is a way to do this without creating a stored procedure

  thanks

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  August 11, 2010 at 11:39 am

  #1205577

  sp_msforeachtable

  Look at this system stored procedure in the SQL BOL

  I would create a stored procedure that uses an input parameter to make this really flexible.

  Andrew SQLDBA

• jerry-621596

  SSCertifiable

  Points: 6096

  More actions

  August 11, 2010 at 11:49 am

  #1205590

  This is a duplicate post. Please do not post a question more than once.

  http://www.sqlservercentral.com/Forums/Forum392-1.aspx