Articles

 Backup all dbs on MSSQL Server

ProblemSometimes things that seem complicated are much easier then you think and this is the...

 DB Table Reindex

USE MCD --Enter the name of the database you want to reindex DECLARE @TableName varchar(255)...

 Find/Replace Script to remove text from a database if it has been edited by SQL Injection

The only thing that needs to change to run this script are the database where you want this to...

 MSSQL SCRIPT - Searching and finding a string value in all columns in a SQL Server table

ProblemSometimes there is a need to find if a string value exists in any column in your table....

 Script to fix orphaned users sql 2008

use saphila;gosp_change_users_login @Action='update_one', @UserNamePattern='octint',...