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

No comments:

Post a Comment