My SQL Server Toolbox
SQL Server Tools:
Graphical monitor tools:
- SQLPMon – process monitor
- SQLBMon – block monitor
- SQLRMon – resource monitor
- SQLSProf – sampling profiler
Command line tools:
- BulkInsert – Command line that wraps BULK INSERT
- BulkXML – Command line that wraps the SQLXMLBulkload interface
- InsertGen – Generate INSERT statements from a SELECT
Extended Stored Procedures:
- XPBCP – Execute BCP in and out from SQL Server
- XPCOMPRESS – Compress text data on the fly
- XPDTC – Troubleshoot distributed transactions
- XPDTS – Execute DTS package from within SQL Server
- XPENCODE – Base64 encoding routines
- XPEVENT – Fire or wait on Win32 Named Events
- XPFILE – Sybase equivalent of xp_readfile and xp_writefile
- XPFILEMGR – File management routines like: DIR, MD, COPY, REN, DEL
- XPGUID – Sequential GUID generation and GUID validation routines
- XPSMTP – SMTP based SQL Mail replacement
Command line scripts:
- SQLLoginEvents – Monitor SQL Server login success and failures
T-SQL scripts:
- track_waitstats, sample_waitstats, report_waitstats
- track_filestats, sample_filestats, report_filestats
- track_umsstats, sample_umsstats, report_umsstats
- sp_getUMSSchedulerID
- ::fn_lock
- ::fn_who
- ::fn_fileexist
SQL Agent Tools:
Graphical tools:
- SQLJobMan – SQL Agent Job Manager based on SQL Namespace and SQL-DMO
- SQLJMon – SQL Agent Job Monitor
Command line tools:
- ProxyTest – Test tool for the proxy account
T-SQL scripts:
- SQL Agent Date & Time function library
- sp_sqlagent_autostart – auto start SQL Agent when SQL Server starts
- sp_sqlagent_enum_errorlogs – enumerate the SQL Agent error log files (SQLAGENT.OUT)
- sp_sqlagent_read_errorlog – read the SQL Agent error log file
- sp_sqlagent_rename – fixup jobs after you renamed your machine name
- sp_sqlagent_proxy_account – retrieve the SQL Agent Proxy settings from the LSE
- sp_sqlagent_config – retrieve all non-documented SQL Agent configuration settings
- sp_sqlagent_jobstatus – retrieve the state of a job, by interrogating xp_sqlagent_enum_jobs
SQL Trace/Profiler Tools:
- DumpTrc – dumps the complete content of a trace file
- SplitTrc – splits trace file in to smaller files
- Trc2Sql – saves the trace file as SQL text (same result as using SQL Profiler Save To SQL)
- Trc2SqlX – save the trace file as SQL script with additional information as #reads, CPU, duration etc.
- Trc2Xml – save traces in to a XML file, with XSD
- System.Data.SqlTrace - .NET provider for reading trace files
- TraceAnalyzer - .NET based tool for analyzing trace content
DTS Tools:
Custom Tasks:
- SMTP – Task that wraps the XPSMTP functionality
- BCP – Task that wraps the BCP.EXE functionality
- Bulk XML – Task that wraps the SQLXMLBulkload interface
- Directory Watcher – Task that fires when content of directory changes
Command line tools:
- Dts2Xml – Save DTS package as XML
- Dts2CS – Save DTS package as .NET C# code
- Dts2VB – Save DTS package as .NET VB code
SQL-DMO Tools:
Graphical tools:
- TransferManager – a replacement of the good old SQL Server 6.5 Transfer Manager
Command line tools:
- ScriptDB – script database
- ScriptDBObj – script database objects
- BulkCopy – wrap BulkCopy object
MS-DTC Tools:
- DTCConf – DTC configuration utility
- DTCTest – DTC tester, tests:
- Creation, enlistment of DTC transaction
- ODBC enlistment and propagation
- OLEDB enlistment and propagation - DTSStress – DTC tools to stress creation and commit/abort of NULL and distributed transactions
- XPDTC – SQL Server Extended Stored Procedure which dumps the DTC transaction information
Win32 Tools:
- SetPF – Changes the %ProgramFiles% location, so that you can place the SQL Server tools installation on another location
- QSVC – Query Service Status, returns %errorlevel% information for retrieving service state in a batch file
- RSCM – Remote Service Control Manager
- RemBoot – Remote Reboot
- WhoAmi – Used to check credential when executing using xp_cmshell, DTS and SQL Agent
- BSync – Fire or wait on Win32 Named Events from a batch file, can be used in combination with xp_event
- ProgID2ClassID – convert a COM ProgID in to a ClassID
- ClassID2ProgID – convert a COM ClassID in to a ProgID
Miscellaneous SQL Server Tools:
- ListSQLSrv – ODBC based SQL Server enumeration
- EnumSQLSrv – LAN Manager based SQL Server enumeration
- OleDbEnum – OLE DB based SQL Server enumeration
- ChngSqlSvcPwd – Change the SQL Server service account password without the requirement to restart the service
- SQL Namespace Browser