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 ...