Articles by Jaume Pascual (Tip/Trick: 1)

No articles have been posted.

No blogs have been submitted.

Database Development
SQL Server	Find all Stored Procedures having a given text in it [Tip/Trick] 25 Oct 2011 Updated: 25 Oct 2011 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 8,110 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. SELECT DISTINCT so.name FROM dbo.sysobjects so inner join .dbo.syscomments sc on so.id=sc.id WHERE so.xtype='P' AND sc.text like '%SearchString%'Much faster!

No reference articles have been posted.

No projects have been posted.

Jaume Pascual

Software Developer (Senior) Multimos

Spain

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.