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]

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON Read More ...

Comments

Setting up per connection Limit Bandwidth on MikroTik Router

Generally, I do not prefer to add any unwanted restriction on the network user until its required due to some Administration reason. I know, there are more ways to tackle this setting up per connection Limit Bandwidth on MikroTik Router question comes into one’s mind but I resolve my concern while using MikroTik PCQs feature in MikroTik Queue Type and then calling this Queue Type to Simple Queue. There are more options for setting up per connection Limit Bandwidth on MikroTik Router but please share your concern to add anything else in this article. Let’s start to add our configurations; I am using WinBox for this Article but you can use anything you are convenient to use. Let’s start Step by Step procedure for Setting up per connection Limit Bandwidth on MikroTik Router, any version. Setup Queue Types After Successful Login, click on Queues menu. Navigate to Queue Types and Press Add + (Plus Sign) to add a new Queue Type. Type a Name like in my scenario,...

DsReplicaGetInfo failed with status 8453 0x2105 on Windows Server 2008

I have two Domain Controller in my envorinment, Primary Domain Controller is Windows Server 2003 based and Additional domain controller is Windows Server 2008 based. When I Installed New 2008 ADC and after some time, when I check with repadmin /showreps found the error.... DsReplicaGetInfo() failed with status 8453 (0x2105):Replication access was denied. I really worried about Solutions: [ DsReplicaGetInfo failed with status 8453 ]

Event ID: 14158 Source: Microsoft Forefront TMG Firewall - How to change intra-array address in TMG 2010

In my organization, we are privious using Microsoft ISA Server 2006 ENT for proxy and gateway purpose. There are two website published on ISA 2006 Server and I install Microsoft TMG 2010, this morning. When I was making installations and configurations of my New Microsoft TMG 2010 Firewall Server with 192.168.10.17 but when I replace server with my existing Microsoft ISA Server 2006 and change Internal IP to my privous gateway IP, Microsoft TMG 2010 start showing events with ID 14158 and Configurations Error with "Description : The IP address specified for communication between this Forefront TMG computer (192.168.10.17) and other array members is not bound to a network adapter installed on this computer. The IP address specified for intra-array communication must be bound to a network adapter installed on the computer." Event ID 14158 Solution - 1: (Easy One) Management Console : Start > All Programs > Microsoft Forefront TMG > Micr...

Rizwan Ranjha

Search This Blog