Tech Space

Experiencing Tech as a Professional Techie

Windows XP Keyboard Navigation

In Explorer:"<ALT>VOU" – Go up one level (View, Go To, Up one level

Stored procedure to search functions and stored procedures.

– Altered slightly from http://www.knowdotnet.com/articles/storedprocfinds.htmlCREATE PROCEDURE Find_Text_In_SP_or_FN (@StringToSearch varchar(100))AS SET @StringToSearch = ‘%’ + @StringToSearch +’%’ SELECT DISTINCT SO.Name FROM sysobjects SO (NOLOCK) INNER JOIN syscomments SC (NOLOCK) on SO.ID = SC.ID AND (SO.Type = ‘P’ OR SO.Type LIKE ‘%F%’) AND SC.Text LIKE @stringtosearch ORDER BY SO.NameGO