How to Find Text Inside Stored Procedure

How to Find Text Inside Stored Procedure - SQL Server

Following SQL will return stored procedures that using supplied string:

CREATE PROCEDURE [dbo].[proc_FindTextInsideSP]
(
@s varchar(50)
)
AS
SET NOCOUNT ON;

SELECT ROUTINE_NAME, CREATED, LAST_ALTERED
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%' + @s + '%'
ORDER BY ROUTINE_NAME;

RETURN;

Comments

Reflector for .Net - amaizing how open your .Net source code

Reflector for .Net - Reflector is the class browser, explorer, analyzer and documentation viewer for .NET. Reflector allows to easily view, navigate, search, decompile and analyze .NET assemblies in C#, Visual Basic and IL. At same site there are also other interesting tools like: Resourcer for .NET - Resourcer is an editor for .resources binaries and .resX XML file formats used with the .NET platform Mapack for .NET - Mapack is a .NET class library for basic linear algebra computations.

Asynchronous pages in C# - When to Use It?

When do we need asynchronous page in ASP.net. Suppose you have a website with two web pages. One is your home page which display's a greeting, and the second page displays a large dataset from a database. You have 25 threads in your thread pool. 25 people simultaneously are accessing the database query page, and one additional person comes onto the site to see the home page which has static content on it. http://davidjberman.com/blogs/csharp/archive/2007/08/13/how-to-create-asynchronous-asp-net-pages-using-c.aspx

Dynamic Data Error - "'DropDownList1' has a SelectedValue which is invalid because …"

During my first investigation of Dynamic Data Support at .NET 3.5 environment, I've found that even Microsoft has bug :-))) After the following great instructions of following screen-cast I've finished in few minutes with applications that allows me to maintain all my database tables. The problem is that already at third screen I've played with I got following error message: 'DropDownList1' has a SelectedValue which is invalid because it does not exist in the list of items. Fortunately, I'm not the first who is plying with Dynamic Data at .NET 3.5 so at this blog you can find fix and good explanation of this bug.

Asp.NET Tips

Search This Blog