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 1202 Source SceCli on domain controller - Solved

I was getting rapidly Event ID 1202 Source SceCli on my domain controller. Security policies were propagated with warning. 0x4b8: An extended error has occurred. Advanced help for this problem is available on http://support.microsoft.com. Query for "troubleshooting 1202 events". – Event ID 1202 Source SceCli It was a newly build Windows Server 2012 Domain Controller. I have scenario like this; Before: Primary Domain Controller: Windows Server 2003 (32-bit) Secondary Domain Controller: Windows Server 2008 (32-bit) Now: Primary Domain Controller: Windows Server 2012 Secondary Domain Controller: Windows Server 2008 (32-bit) After successfully DC promotion and after a week, I start getting Event ID 1202 on newly build server. L I tried various solutions but nothing was great except the below one; Solution ( Caution ): Start > Type CMD > Run As Administrator (Open it on Windows Server 2012: Domain Controller) Type dcgpofix /ignoresche...

Rizwan Ranjha

Search This Blog