Copy One Schema to Another Schema

This script copies one object in another multiple schema.

List all tables without LOB columns

Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml).

Useful when rebuilding indexes online.

Find gaps in primary keys across multiple databases

Output table of gaps in a primary key across multiple databases on same, remote and/or linked servers.

Detach All User Databases

Detach all user databases on a SQL 2008 instance

Consultando LDAP via SSMS

A query tem o objetivo de consultar o status do usuario AD via Management Studio.

Rastreando SysAdmin Habilitado

Script tem o objetivo de encontrar login com a role SysAdmin e informar seu status.

Find Latest Backup

Finds the last full backup file stored in a given folder.

Change Time Zone on Server without Logging on to Box

Sometimes logging onto a box for a simple change like this is not possible for the business. This allows you to change this directly from T-SQL without having to log on or RDP into the box.

Tracking processes

This script quick tip for those who will accurately monitor sessions on SQL Server.

Allow distributed transactions

SQL Script to Open DTC for distributed transactions and also configure SQL Server for Distributed Transactions.