How to search "Data" or "Keyword" in all tables in your Microsoft SQL database

Being a System Administrator, most often I required to search a keyword within a database and During Google search, I come to know that a Microsoft SQL Server store procedure can help in this regards. Mean, you can find any keyword in your database. I found a great example and with little modification, I am able to search any keyword or string in my database. Here is it;

SOLUTION : 

 

USE [DATABASENAME]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON Read More ...