DatabaseJournal.com Staff

This stored procedure can be used to create a huge database spread across one or more data and log devices. It uses the next available device number and creates database devices based on the @DbName. It accepts the following parameters: @DbName = Name of the database you want to create. This name will be used […]

  This procedure returns the position of a column within a table. If no column is specified then the postition of all columns is displayed. Author: Jarlath J. O’Grady   Download Script: sp_columnpos.prc Download Help File: sp_columnpos.rtf   Disclaimer: We hope that the information on these script pages is valuable to you. Your use of […]

  This procedure returns number of rows within a table. If no table name is specified then the number of rows for all tables is displayed. Author: Jarlath J. O’Grady   Download Script: sp_rows.prc Download Help File: sp_rows.rtf   Disclaimer: We hope that the information on these script pages is valuable to you. Your use […]

by Andrew Chen Performing User Authentication via MySQL In my last article covering MySQL and Web servers, I talked about creating a guest book that would allow our visitors to leave a message for everyone to see. This was all fine and dandy; however, there is more that we can do with a Web site […]

This tool will generate INSERT statements reflecting the data in a user table. You’ll need to set your Query Analyzer connection to “comma delimited” to get this to work, and it isn’t guaranteed against every datatype, but it’s a real timesaver. Author: S Eldridge Download Script: GenInserts.SQL Disclaimer: We hope that the information on these […]

It is most likely that a DBA would like to be notified when automatic database file growth occurs. This script does the following: add a user-defined error message to state that file size has changed create an alert for that message. This alert will send email to . create a table to store file size […]

This script is designed to shrink those databases that do not appear to respond to doing the DBCC ShrinkDB command alone. Author: Kevin Eberwein Download Script: ksp_ShrinkDB.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 […]

This is a slight modification of the SP_Who SP, modified my MFrank, so that it displays information that is actually needed, and cutting back on the amount of junk displayed. System processes and inactive processes are not displayed. Column formatting has been modified to display most relevant columns on one screen. Most of the modifications […]

This is used for a situation where you may have a tree view control that you need to select data that belongs to the parent and all its children. Just pass a string (varchar(4000)) to the proc as a parameter. Then use this routine to parse it out. This will work like the xp_Tokenize Extended […]

Lists all indexes for each tables with the type of each indexes. Execute the stored procedure against the database that you need to find out about the indexes. Author: Eddy Djaja Download Script: psp_help_allidx7.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in […]

Lists all indexes for each tables with the type of each indexes. Execute the stored procedure against the database that you need to find out about the indexes. Author: Eddy Djaja Download Script: psp_help_allidx7a.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in […]

The usp_UtilReplicationSchema stored procedure will list the published servers, databases, publications, articles, subscribed servers and databases per user query conditions. To Run : EXEC usp_UtilReplicationSchema @publishedServerName = ‘PublishedServer’, @publishedDatabaseName = ‘PublishedDatabase’, @publicationName = ‘Publication’ @articleName = ‘PublishedTable’ @subscribedServerName = ‘SubscribedServer’, @subscribedDatabaseName = ‘SubscribedDatabase’, Author: Kenny Adeniji Download Script: usp_UtilReplicationSchema.sql Disclaimer: We hope that the information […]