Simple Object and String Search within Objects

• Kartik M

  SSChasing Mays

  Points: 644

  More actions

  September 5, 2016 at 3:06 am

  #321267

  Comments posted to this topic are about the item Simple Object and String Search within Objects

  Thanks & Regards, Kartik M Kumar..

• André Nel

  Grasshopper

  Points: 19

  More actions

  September 26, 2016 at 12:54 am

  #1903022

  This is fantastic. Thank You

  I often search for things, but change the DB manually.

  I often search for column names as well, so took the liberty in adding the below in your coding format to search for column names as well.

  Set @Command = ''

  Set @command = N'Insert into ##t001 Select ''[?]'' DataBaseName, o.name+'' - ''+c.name Object_name,''Column'' ObjectType, ''''

  from [?].sys.objects o Join [?].sys.columns c On c.object_id = o.object_id where c.name like ''%'+@SearchText+'%'''

  Execute sp_MSforeachdb @command, N'?'

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  September 26, 2016 at 7:13 am

  #1903074

  Nice script. I will have a use for this. Thanks.