Need help in creating Stored Procedure for searching database

• venu_ksheerasagaram

  SSCommitted

  Points: 1911

  More actions

  September 24, 2009 at 1:17 am

  #226481

  Hi Friends,

  I am facing a problem in writing a stored procedure for searching entire database(All tables) when a word is given as input.

  Please provide me your valuable suggestions. and the ways of the stored procedure to write.

  Thank you in advance,

  Venu Gopal.K
  Software Engineer
  INDIA

• dmoldovan

  SSCertifiable

  Points: 6334

  More actions

  September 24, 2009 at 1:40 am

  #1057885

  See if dynamic SQL is helpful - you can start at http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=DynamicSearch, however in my opinion the most valuable resource is http://www.sommarskog.se/dynamic_sql.html#Dyn_DB.

  Explore also the full text feature - BOL is a good starting point.

  This article may also interest you:

  http://www.sqlservercentral.com/articles/Full-Text+Search+(2008)/64248/

• arun.sas

  SSChampion

  Points: 11831

  More actions

  September 24, 2009 at 4:00 am

  #1057923

  exec sp_MSforeachdb "select '?' As DatabaseName,name from ?.dbo.sysobjects where name like ('%MYTABLE%')"