DatabaseJournal.com Staff

Lists the replication commands stored in the distribution database. To Run : EXEC usp_UtilReplicationBrowseCommands @publishingServerName = ‘PublishedServer’, @publishingDatabaseName = ‘PublishedDatabase’, @articleName = ‘PublishedTable’ Author: Kenny Adeniji Download Script: usp_UtilReplicationBrowseCommands.SQL Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at […]

Find the age of your database by day. SP_AGEOFDATABASE will tell you, in days, when each of your databases were created. Author: Rob Vallee Download Script: sp_AgeofDatabase.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole […]

Loads a time dimension for a Data mart, Data warehouse, etc. The only variables to change are the increment (an integer for days or weeks or months), the Start date and the End date. The script will loop through and load the table. Author: Dean Sowards Download Script: time_dimension.sql Disclaimer: We hope that the information […]

SP_WASTEDSPACE will scan you tables for every column, finding out how much you’re using of each column and report how much of that space allocated you’re wasting. For example : if you have a varchar(255) and you’re only at any given time using 20 characters @viewtype (compact or full) – displays how much information […]

Returns the nth delimted piece of a text string. I use an automation object within a stored procedure that returns a caret delimited string, this lets me parse out the data I need to update the required table. Works with SQL Server 7.0. Author: Keith R. Davis Download Script: sp_piece.sql Disclaimer: We hope that the […]

by Andrew Chen Introduction In this age of the full-service internet, the demand for bigger and badder websites will only increase. To meet the demands of these full-service websites, the SQL database servers come into play. One of the more popular SQL servers available for download on the internet is MySQL. MySQL is not released […]

Use to determine whether a column(s) would be a good candidate for an index. Compile this procedure in the master database so that it can be used on any user database. Author: Doug Bass Download Script: sp_help_selectivity.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the […]

This program it4s similar to Sqlcomp from Backoffice Resource Kit. With this program your can compare Stored Procedures and Views from different servers (example: Production and Developer) and versions (6.5 and 7.0). I use “Server A” like source server and “Server B” target server, if there are different objects the log button will be enabled. […]

This query gives you a quick look of database of SQL Server 7.0. I find it useful as it gives all database names, their status, create date and its path. Author: SU GE Download Script: sp_alldbinfo.SQL Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information […]

Fed up as I was of having to amend my backup script every time someone created or deleted a user database I came up with the following script. It will dump every database to the Tape backup device (except tempdb), it does this dynamically by looking in sysdatabases. Author: Ryan Waight Download Script: sp_backup_all.SQL Disclaimer: […]

This script was created as a quick look inside any SQL 7 database. I find it very useful for comparing tables, column and datatypes. It will list table name, column name, datatype, column length, nullability and object type. Author: Robert Vallee Download Script: sp_dbinfo.SQL Disclaimer: We hope that the information on these script pages is […]

This stored procedure can be used in conjunction with sp_revdatabase to script important information on the configuration of the SQL Server Database devices and databases, for use in SQL Server recovery situations. Notes: * This Procedure assumes that all devices are created on the same segment. If not do not use this stored procedure. * […]