SQLServerCentral.com Scripts tagged SQLInsider Scriptshttp://www.sqlservercentral.com/Scripts tagged SQLInsider Scripts posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Generate Job Schedule DescriptionsA SELECT statement which includes the alpha description of each job's schedulehttp://www.sqlservercentral.com/scripts/Maintenance+and+Management/61448/2008/01/07http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61448/A Simply way to implement Audit Trail in SQL 2005http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/32008/2007/09/20http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/32008/LSTR() and RSTR(): Enhanced LEFT() and RIGHT()http://www.sqlservercentral.com/scripts/Miscellaneous/32002/2007/09/13http://www.sqlservercentral.com/scripts/Miscellaneous/32002/Server Up-Time Informationhttp://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31994/2007/11/15http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31994/Get all user def table info with rowcount and sizehttp://www.sqlservercentral.com/scripts/Miscellaneous/31992/2007/11/19http://www.sqlservercentral.com/scripts/Miscellaneous/31992/Delete Duplicates using CTEhttp://www.sqlservercentral.com/scripts/Miscellaneous/31989/2007/08/23http://www.sqlservercentral.com/scripts/Miscellaneous/31989/Table row count using 3 different wayshttp://www.sqlservercentral.com/scripts/Miscellaneous/31984/2007/08/31http://www.sqlservercentral.com/scripts/Miscellaneous/31984/Verify Errorloghttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31925/2007/09/12http://www.sqlservercentral.com/scripts/T-SQL+Aids/31925/Function to Split a Delimited String into a Tablehttp://www.sqlservercentral.com/scripts/Miscellaneous/31913/2007/05/25http://www.sqlservercentral.com/scripts/Miscellaneous/31913/Send SMS from a triggerhttp://www.sqlservercentral.com/scripts/Miscellaneous/31899/2007/04/16http://www.sqlservercentral.com/scripts/Miscellaneous/31899/SQL Server 2005: Script all Indexeshttp://www.sqlservercentral.com/scripts/Miscellaneous/31893/2007/03/27http://www.sqlservercentral.com/scripts/Miscellaneous/31893/SQL Server 2005: Script all Primary Keyshttp://www.sqlservercentral.com/scripts/Index+Management/31892/2007/03/28http://www.sqlservercentral.com/scripts/Index+Management/31892/Script SQL Database DDLhttp://www.sqlservercentral.com/scripts/Miscellaneous/31882/2007/03/12http://www.sqlservercentral.com/scripts/Miscellaneous/31882/AUDIT WITH A TWISThttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31881/2007/03/13http://www.sqlservercentral.com/scripts/T-SQL+Aids/31881/Script SQL Server DDLhttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31869/2007/08/20http://www.sqlservercentral.com/scripts/T-SQL+Aids/31869/Calculating Percentage Changehttp://www.sqlservercentral.com/scripts/Miscellaneous/31868/2007/03/02http://www.sqlservercentral.com/scripts/Miscellaneous/31868/Check and Set Default file Locations with TSQLhttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31854/2007/01/01http://www.sqlservercentral.com/scripts/T-SQL+Aids/31854/Way to Delete duplicate rows in a table.http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31842/2007/08/07http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31842/Finding other database objects referenced in an SPhttp://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31836/2007/07/31http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31836/Show Line of Code Executing in Procedurehttp://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31818/2007/07/18http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31818/Proper Luhn AddCheckDigit for any length #http://www.sqlservercentral.com/scripts/Miscellaneous/31813/2006/01/12http://www.sqlservercentral.com/scripts/Miscellaneous/31813/Table Variableshttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31812/2006/01/15http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31812/Make a time value from a given float valuehttp://www.sqlservercentral.com/scripts/Miscellaneous/31804/2007/07/04http://www.sqlservercentral.com/scripts/Miscellaneous/31804/Search Data in Databasehttp://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31796/2006/09/29http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31796/Stored Proc to List Columns for a Primary Keyhttp://www.sqlservercentral.com/scripts/Miscellaneous/31794/2006/09/14http://www.sqlservercentral.com/scripts/Miscellaneous/31794/Random Number Generatorhttp://www.sqlservercentral.com/scripts/Miscellaneous/31793/2006/09/15http://www.sqlservercentral.com/scripts/Miscellaneous/31793/Get Primary Key columns of given MSSQL tablehttp://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31787/2007/02/14http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31787/Get Foreign Key of all the tables for Sqlserver DBhttp://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31786/2006/09/25http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31786/get rich schema details of all or some tableshttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31766/2006/08/30http://www.sqlservercentral.com/scripts/T-SQL+Aids/31766/Overcome BCP limitations for output to CSV filehttp://www.sqlservercentral.com/scripts/Miscellaneous/31756/2006/07/03http://www.sqlservercentral.com/scripts/Miscellaneous/31756/