Procedure to Search any sql Object

use master go
CREATE PROC dbo.sp_ob
(
@name SYSNAME= NULL,
@type VARCHAR(5)= NULL
)
AS 
/*
Sample Procedure Call (procedure can be called from any database as it is created on Master database with stored procedure name begin with sp_)
EXEC sp_ob 'abc','u
*/BEGIN
DECLARE@nmSYSNAME

SET @nm = LTRIM(RTRIM(ISNULL(@name,'%')))

IF (CHARINDEX('%',@name)=0)
BEGIN
IF (LEFT(@nm,1)<>'%' AND @nm<>'%')
SELECT@nm= '%' + @nm

IF (RIGHT(@nm,1)<>'%' AND @nm<>'%')
SELECT@nm= @nm + '%'
END

SELECT*
FROMsysobjects
WHEREtype = isnull(@type,type)
ANDname LIKE @nm
ORDER BY NAME
END
GO