Skip to main content

You are here

Programming

Search the entire Database for an Object containing a string

This query searches the entire database for objects containing the indicated string. This, among other uses, is good for locating a piece of code no mather where they reside in the database.

SELECT DISTINCT OBJECT_NAME(ID)
FROM SYS.SYSCOMMENTS
WHERE TEXT LIKE '%[TEXT TO SEARCH FOR]%'

Tags: 

Video tutorial on NUnit + c# implementation

I found this excellent video on NUnit implementation on c#. The video takes some time to load but its worth waiting for.
http://ndc2011.macsimum.no/SAL5/Onsdag/1020-1120.wmv

Premium Drupal Themes by Adaptivethemes