Tuesday, February 18, 2014

How to search for a string in all the objects in SQL Server 2008

Please find the code below to find a particular string in all the objects in SQL Server
 SELECT DISTINCT o.name AS Object_Name,o.type_desc
FROM sys.sql_modules m
INNER JOIN sys.objects o
ON m.object_id=o.object_id
WHERE m.definition Like '%YOUR_STRING%'
YOUR_STRING is the string that you want to search.This will search the above string in tables,sps and views.

Share this

1 Response to "How to search for a string in all the objects in SQL Server 2008"

  1. If you stick round, you’ll uncover whether Shazam is the proper on-line on line 온라인카지노 casino for you. Wagering on pro and faculty sports became authorized in September of 2019 with each cellular and in-person betting permitted at a number of} areas. Legislation was handed in June to allow sports gambling, though in-state collegiate video games shall be off-limits under the new new} regulation. It will make gambling lawful in selection of|quite lots of|a wide selection of} areas each in-person and on-line. Bets on collegiate video games can solely be positioned in individual, not on-line.

    ReplyDelete