Tag: Stored procedure text search
-
How to search text at all Ms SQL tables, fields and all object?
1. Create the following Stored Procedure at the database you want to search: CREATE PROCEDURE SearchTables @Tablenames VARCHAR(500) ,@SearchStr NVARCHAR(60) ,@GenerateSQLOnly Bit = 0 AS /* Parameters and usage @Tablenames — Provide a single table name or multiple table name with comma seperated. If left blank , it will check for all the tables in…