Database Scripts

Beta
 Log In    |   Sign Up

SQL Server : Finding DB objects

Added on Jun-11-2012 by venushakamuri
For SQL Server

Tags : sql

finding db objects

Versions

sql

DOWNLOAD

@name varchar(120),  
@type varchar(5)  
as  
begin  
declare @Sql varchar(500)  
set @Sql = 'select * from sysobjects where name like ''%' + @name +'%'' and type = '''+@type+''' order by name'   
print @sql  
Exec (@sql)  

    

Report Script

blog comments powered by Disqus