SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by wfvdijk / Search in your T-SQL objects / Latest Posts

RE: Search in your T-SQL objects

JStiney — Mon, 16 Nov 2009 12:22:02 GMT

Thanks rVadim,I changed the ??? to blanks and the script works for me.declare @SearchCriteria nvarchar(100)set @SearchCriteria = '%MEAG_MASTER%' ---------> enter criteria hereselect distinct @SearchCriteria as ZoekCriteria , 'in code' as Classification , b.type_desc , object_name(a.id) "ObjectName" , b.modify_datefrom syscomments ainner join sys.objects b on a.id = b.object_idwhere a.encrypted = 0 and a.text like @SearchCriteriaunionselect @SearchCriteria , 'in code' as Classification , 'SYNONYM' , name , modify_datefrom sys.synonymswhere base_object_name like @SearchCriteriaunionselect @SearchCriteria , 'in code' as Classification , 'CHECK_CONSTRAINT' , name , modify_datefrom sys.check_constraintswhere definition like @SearchCriteriaunionselect @SearchCriteria , 'in code' as Classification , 'DEFAULT_CONSTRAINT' , name , modify_datefrom sys.default_constraintswhere definition like @SearchCriteriaunionselect @SearchCriteria , 'as columnname' as Classification , 'COLUMN' , object_name(object_id) collate database_default , NULLfrom sys.columns where name like @SearchCriteriaunionselect @SearchCriteria , 'in objectname' as Classification , type_desc collate database_default , name collate database_default , modify_datefrom sys.objects where name like @SearchCriteriaorder by 1,2;

RE: Search in your T-SQL objects

rVadim — Mon, 16 Nov 2009 11:50:35 GMT

I've got that error too. When pasted in Notepad++ it looks like this:select????distinct ????????@SearchCriteria as ZoekCriteria????????, 'in code' as Classification????????, b.type_desc????????, object_name(a.id) "ObjectName" ????????, b.modify_datefrom????syscomments ainner????join sys.objects bon????????a.id = b.object_idwhere????a.encrypted = 0and????????a.text like @SearchCriteria--Vadim.

RE: Search in your T-SQL objects

JStiney — Mon, 16 Nov 2009 10:09:37 GMT

Wilfred,I get the following message on the select statement when I inserted set @SearchCriteria = '%MEAG_MASTER%' and executed the script.Any suggestions?Msg 170, Level 15, State 1, Line 5Line 5: Incorrect syntax near ' '.Line 5 is the select.

Search in your T-SQL objects

Wilfred van Dijk — Wed, 21 Oct 2009 07:48:44 GMT

Comments posted to this topic are about the item [B]Search in your T-SQL objects[/B]