Have you ever had that rare situation where you need log shipping to another server, but have zero access to the primary server? I encountered that issue recently and my solution was two parts. A Secondary Log Shipping Target without a Primary. Pretty Cool. I had the need to consume transaction logs into a StandBy(ReadOnly)…
Author: StormAdmin
envwhoip
a whoisactive that also returns IP address
envwhodmv
dmv query like sp-whoisactive, includes IP Address
envwhodb
user activity in specific or current db
envwhobak
finds currently running backup or restore commands
envwhoami
colleciton of built in functions about you and your connection
envwho
sp_whoisactive with transactions and more
envvlf
gets the count of virtual log files in all databases, and the script to reduce them
envvfailedjobs
list of all failed jobs
envusersmsdb
greatly improved scripting of users and permissions