Search objects used in database

Below is the stored procedure which will query the database and find the list of objects which match the search string specified.

CREATE PROCEDURE [dbo].[sp_Search_sProcs] @searchText varchar(100) AS SELECT sysobjects.name FROM sysobjects, syscomments WHERE syscomments.id = sysobjects.id and
sysobjects.xtype = 'P' AND sysobjects.category = 0 AND syscomments.text LIKE '%' + @searchText +'%'
ORDER BY sysobjects.name
GO

Comments

Post a Comment

Popular posts from this blog

Error when Installing SQL Server 2008 R2 Management Studio

Yesterday, I downloaded and tried installing the 64bit version of the Sql Express Mangement Studio, but I received the below error message   Another version of Microsoft Visual Studio 2008 has been detected on this system that must be updated to SP1. Please update all Visual Studio 2008 installations to SP1 level, by visiting Microsoft Update This message was particularly baffling since my laptop was a new build and I had installed VS 2010 only. On further investigation I found that one of the software installation that I did had installed VS 2008 components. The Add Remove programs in Control panel wasn't helpful. I used the VS2008 uninstall tool from microsoft site http://go.microsoft.com/fwlink/?LinkId=105801 This removed the VS2008 instance completely. I reran the setup for Management Studio and all worked well. To do it manually try http://blogs.msdn.com/b/joy/archive/2008/10/21/how-to-remove-visual-studio-2008-manually.aspx Hope it works out for you..
Read more

Windows 7 and GoToMyPC - Configure the Domain Group Policy to allow GoToMyPC to send Ctrl-Alt-Del

After installing Windows 7, I was unable to logon to the office computer using GoToMyPC. It came up with an error message along the lines of ‘The Domain Group Policy for this computer does not allow GoToMyPC to send Ctrl +Alt +Del. please contact your administrator'. I tried following the instructions given in the documentation of GotoMyPC's 'Pro Administrator Guide' till point 7, which read, I quote "Locate the Group Policy Object (GPO) in the domain or sub-domain that contains the policy that is preventing GoToMyPC from sending Ctrl-Alt-Del.". I spent some time looking for this policy but couldn't. I then started digging further into this issue and came across the concept of 'Secure Attention Sequence' which is basically a special sequence of events that enables a user to log on or off a computer, and how Windows Vista/Windows 7 introduced a new group policy setting which controls whether or not software can simulate a SAS. I solved my pr...
Read more

Technical Team Lead Interview Questions

Following are some of the questions which can be asked for a technical team lead interview: a. if you have a non performing developer in your team, how will you deal with them (Question relates to Motivation)? b. Have you ever had a project, that you were working on was in danger of missing the deadline and were you able to bring it back to schedule? if so how? c. Have you ever been part of recruiting members of the team? d. What document will you give to your developer when developing a requirement. State the details that will be included the document. e. What are your strengths and weaknesses? f. if we ask your team, what will your colleagues describe as your strengths and weaknesses.
Read more