DatabaseJournal.com Staff

SP_AXEUSERS sends out a net send message to all users connected to a user defined database and then disconnects them thirty seconds later. Simply run SP_AXEUSERS @USRDB = ‘MYDATABASENAME’ (‘MYDATABASENAME’ being the variable). Make sure that you are out of the database yourself before you run the stored procedure. I would recommend that you do […]

Need to drop a database? Don’t forget to clean up the related tasks, devices, files, logons, etc. Here’s a script to clean up some of the most common items related to a database. For SQL Server 6.5 Author: Cindy Gross Download Script: sp_DropDBandRelatedItems.SQL Disclaimer: We hope that the information on these script pages is valuable […]

This new job will utilize SQL-DMO and FSO to script your jobs and save the results to a text file. A pre-job step could be included to create a backup copy of any existing files if you wish. A couple of gotcha’s… 1) This job requires a properly installed and functioning scrrun.dll to reside on […]

This script returns rowcounts for all tables in the current database, or if @tablename is provided, for that table only. Author: Doug Bass Download Script: sp_rowcount.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 risk. […]

Provides RAS dial and disconnect extensions to SQL Server. (This is a DLL that you can call from within SQL Server). Author: Nathan Allan Download Script: rasext.zip 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 […]

If you ever have to pass a long list of integer or varchar values to SQL Server from frontend software – use xp_Tokenize to separate that list of values from inside a stored procedure, then put that data to use. Author: Anthony B. Kenitzki Download Script: tokenizesource.zip Download Script: tokenizedll.zip Disclaimer: We hope that the […]

If you ever have to pass a long list of integer or varchar values to SQL Server from frontend software – use xp_Tokenize to separate that list of values from inside a stored procedure, then put that data to use. Author: Anthony B. Kenitzki Download Script: Tokenizesource2.zip Tokenizedll2.zip Disclaimer: We hope that the information on […]

Here is a stored procedure that works as a limited version of the Access Transform/Pivot table clause. Pass in a table and relevant columns, and voila crosstab generated. The sp returns both the result of the crosstab query and the sql statement used in this version. Author: kim@renaissance.co.il Download Script: sp_cross.sql Disclaimer: We hope that […]

This is a sql script that will list all the table names a particular field name belongs too. Let’s say you have over 100 tables in an employee database and you would like to see what tables have the field name EmployeeID. It will return all the tables in asc order with the field name […]

by Jessie Cui Is that feasible to dynamically create DSN and check data via internet from any computer? This small application, named as SQLmap, is valuable for those who is responsible for building or maintaining a web site and SQL Server database. This apllication helps to access all servers and then access all databases stored […]

Forget having to type Select col1,col2,col3 from table name. Simply pass the name of the table and a select statment will be automatically generated for you. Note: this is only for use with ISQLW or other tools which can view the results of a print statement. Author: Ron West Download Script: sp_select7.sql sp_select.sql Download Script: […]

*** WARNING – DESTRUCTIVE SCRIPT *** Use at your own risk! Break it – can you fix it??? This script will truly corrupt a database. It should not be run on ANY real database. It is only for simulating corruption for training purposes. Author: Sharon Dooley Download Script: sp_corruptdb.sql Disclaimer: We hope that the information […]