SQLCMD or BCP

Are disk volumes fragmented on server? Does it require to be defragged

Disk Fragmentation is one of the cause of degraded performance. Use this script for fragmentation analysis report.

Fecth complete system information from multiple servers

This one line DOS script fetches Hardware Make and Model
OS Name, Edition (for 2003) and version
System Uptime
Processors,
RAM etc.

Get DBObjects with Specified Owner

A database can have objects with multiple owners. The script will give you the list of all the TABLES, VIEWS and PROCEDURES having the specified owner. Just input the owner name and it will give you the list of all the Objects with that owner. This scope of the script is limited to the TABLES, […]

Know the JOBNAME and JOBOWNER

As an administrator it is required sometimes to list out the job owners.This is a simple script that will allow to fetch this information. By applying a filter a specific job owner list can be fetched.