Månedsarkiv: marts 2015

Search for a text inside all the stored procedures in a database.

Udgivet den 26. marts 2015 af seo

SELECT DISTINCT o.name AS Object_Name, o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_id = o.object_id WHERE m.definition Like ‘%%’;

Udgivet i SQL Server - scripts | Kommentarer lukket til Search for a text inside all the stored procedures in a database.