| Script | Compat | |
| SQL Agent Job History Graph |
SQL Server 2000 and later |
Read More |
| AutomaticMechanismsCanBeSurprising.sql |
SQL Server 2005 only |
Read More |
| 2005 Blocking Locks RDL for Management Studio |
SQL Server 2005 only |
Read More |
| 2005 Database Monitor RDL for Management Studio |
SQL Server 2005 only |
Read More |
| 2005 Online Index Rebuild using DMV |
SQL Server 2005 only |
Read More |
| SQL Server 2005 - Backup, Integrity Check and Index Optimization |
SQL Server 2005 only |
Read More |
| dba3_IndexTuning_IndexUsage |
SQL Server 4.2 and later |
Read More |
| dba3_TryCatchErrorHandling_demo |
SQL Server 2005 only |
Read More |
| Database Manager |
SQL Server 2000 only |
Read More |
| dba3_AttachCreateMsSqlSystemResourceDatabaseCopy |
SQL Server 2005 only |
Read More |
| dba3_TablePurgeScriptGenerator |
SQL Server 2005 only |
Read More |
| dba3_TablesWithNoPrimaryKeys |
SQL Server 2005 only |
Read More |
| dba3_sys_ProceduresInDBMSCacheViewScript |
SQL Server 2005 only |
Read More |
| GCF/LCM Factors and Multiples |
SQL Server 2000 and later |
Read More |
| Find String In View Definitions |
SQL Server 2000 and later |
Read More |
| Script SQL Database DDL |
SQL Server 2000 and later |
Read More |
| Remove Orphaned Users |
SQL Server 2000 and later |
Read More |
| dba3_regReadregWrite |
SQL Server 7.x and later |
Read More |
| Database Snapshot SP |
SQL Server 2005 only |
Read More |
| Date Matrix |
SQL Server 2000 and later |
Read More |
| dba3_move_SqlServer2K_TempDB_demo |
SQL Server 2000 only |
Read More |
| Parent Child recursive Query |
SQL Server 2005 only |
Read More |
| Multiple CTE In side a Single View |
SQL Server 2005 only |
Read More |
| How to set low/high groupings by size parameter |
SQL Server 6.x and later |
Read More |
| mfnCalculateHoursMinutes (shift time) |
SQL Server 2000 and later |
Read More |
| stringparsing methods and variants |
SQL Server 7.x and later |
Read More |
| dba3_LOGSHIPPING_TABLE_CONTENTS |
SQL Server 2000 only |
Read More |
| Avoid loginfo being rolled back (T-SQL solution) |
SQL Server 2000 and later |
Read More |
| Flag only the duplicate Rows |
SQL Server 7.x and later |
Read More |
| Article - Sequence Table Script, String Functions |
SQL Server 2000 and later |
Read More |
| sp_scripttable |
SQL Server 2000 only |
Read More |
| Table Size Listing |
SQL Server 2000 only |
Read More |
| Force SQL Error Log Switch |
SQL Server 2000 only |
Read More |
| getWeekDay |
SQL Server 6.x and later |
Read More |
| list_userTablePermissions |
SQL Server 7.x and later |
Read More |
| drop and recreate ALL FK, UQ, DF in a database |
SQL Server 2000 and later |
Read More |
| Generate Object Permission SQL DDL Statements for All User Tables |
SQL Server 2000 and later |
Read More |
| ISOweek |
SQL Server 2000 and later |
Read More |
| julian2DateFvF |
SQL Server 2000 and later |
Read More |
| Auto CRUD Procedure Generator Script |
SQL Server 7.x and later |
Read More |
| List all Active Sessions on a SQL Server 2005 BOX |
SQL Server 2005 only |
Read More |
| List of all open connections on SQL 2005 SERVER |
SQL Server 2005 only |
Read More |
| Create Entity Attribute Values |
SQL Server 4.2 and later |
Read More |
| Simple script to APPEND text onto an NTEXT field |
SQL Server 2000 and later |
Read More |
| List index information for the current database |
SQL Server 2000 and later |
Read More |
| List index information for all databases |
SQL Server 2000 and later |
Read More |
| Bankers Rounding UDF |
ANSI/SQL92 |
Read More |
| Chage object owner |
SQL Server 2000 and later |
Read More |
| Create_Get_Proc |
SQL Server 2000 and later |
Read More |
| Create_Update_Proc |
SQL Server 2000 and later |
Read More |