The Wayback Machine - https://web.archive.org/web/20071011005849/http://www.databasejournal.com:80/scripts/


Free Newsletters:
DatabaseJournal  
DBANews
Database Journal Search Database Journal:
 
HOME News MS SQL Oracle DB2 Access MySQL PostgreSQL PHP SQL Etc Scripts Links Discussion
internet.com

» HOME
» NEWS
» FEATURES
» SERIES
MS SQL
Oracle
MS Access
MySQL
DB2
» RESOURCES
Products
Scripts
Links
» DISCUSSION
» TECH JOBS

internet.commerce
Be a Commerce Partner
Graphics Cards
GPS
Compare Prices
Computer Deals
Corporate Awards
Free Credit Score
KVM over IP
Holiday Gift Ideas
Mortgage Refinance
Plasma Televisions
Giveaways
Mp3 Player Reviews
Laptop Computers
Register Domain Name




Online Ad Revenues Up Despite Consumer Concerns

Guilty Verdict in Nation's First Music Downloading Jury Case

Microsoft Relents on WGA Requirement For IE 7

internet.com
IT
Developer
Internet News
Small Business
Personal Technology
International

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers



Whitepaper: Using VoIP to Keep Corporate Travelers Connected to their Desktops. Intel IT piloted a "soft phone" solution that lets employees access their phone extensions over the Internet.


  Navigating Your IT Career
A career in information technology usually has its share of ups and downs. Download this Internet.com eBook to learn where the jobs are in IT, how to negotiate a salary, and helpful advice on job security and how to deal with a layoff. »
 
  Inside Spyware: A Guide to Finding, Removing, and Preventing Online Pests
Your organization's computers are possibly being used to send spam, harvest e-mail addresses, make purchases on stolen credit cards or take part in denial of service attacks. Learn how to indentify, avoid, and remove malware from computers and keep your network and machines safe. »
 
  Tips for Selecting Software Vendors
IT managers need a proven, steadfast process for sifting through the hundreds of choices available for each enterprise software market segment. There are a series of steps for ensuring a result that will survive the intense, long-term scrutiny this level of investment will certainly attract. »
 
  Storage Basics: A Guide to the World of Storage Technology
Regardless of industry, size, or age, businesses are awash in more data than ever before. Federal regulations require that data be stored, protected, and retrievable for a certain amount of time. Storage is also a growing area in IT, which means employment opportunities exist now, and should exist for some time. »
 
  Building Your Own IP PBX
If you're already into having control of your computing infrastructure, taking charge of your telephone network is a natural progression. Asterisk is an open source PBX that runs on Linux. It can free your organization from expensive commercial PBXs, and gives you complete control over your telephone services »
 
SQL Scripts
Session Information 10/05
Use this script to find the session information.

SQL trace and TKPROF in SQLPLUS 10/01
Purpose: To read raw session trace file with option to format trace file with TKPROF and read it in SQLPLUS Session.

Table Compare 9/24
This sp can compare two tables with the same structure.

Script to Display Current SQL Activity 9/17
A simple stored procedure for SQL Server 2000 (should work on SQL 7 as well) that lists users (like sp_who), locks (like sp_lock), and the input buffers of blocked and blocking users.

Hierarchial Loop I 9/10
This procedure finds all the employees working under 'KING' from the 'SCOTT.EMP' table.

Generate UserNames 9/04
This udf_SuggestUserName function generates usernames based on date of birth, zipcode, username, firstname and lastname.

Delete Old Files 8/27
This procedure deletes files that are older than a certain period from a folder.

Automated script to retrieve structure of all databases on a given server 8/14
This automated script retrieves the structure of all databases on a given server.

Delete all duplicate records in a table 8/13
This script will delete all duplicate records in a table.

DTS Package for Reporting Low Disk Space 8/06
This VBscript code will check for low disk space on the local SQL Server. The script will check all disks except the C: drive and will trigger an alert to be sent via e-mail when the available disk space on any drive falls below 20%.

GET DATABASE OBJECT 's DDL's 7/30
Get any database object ddl's.

Database Size 7/23
This script checks your database size.

Script to Transfer Tables to New Filegroups 7/16
This program will dynamically build and issue drop and alter statements in order to move all the tables in a database to new filegroups.

Wait Sessions 7/06
The Script lists the Session ID,Event Name,Time Waited on the Database.

Lock Monitoring 7/02
You can run this script on any Oracle version of a database to find out the lock details.

Add Your Script

SQL Scripts Archives

Whitepaper: Using the .NET Framework to Increase Performance, Availability, & Business Agility
Keep up with the latest business and technology news and information! Visit Internet.com.
Whitepaper: Linux vs. Microsoft--Making the Right Choice for Your Client-Server Infrastructure.
EMC ApplicationXtender (AX): Learn how you can quickly capture, organize, & deliver info.
Stay up to date! Get real-time news and reviews about the latest innovations in internet technology.


Latest Forum Threads
SQL Scripts Forum
Topic By Replies Updated
SQL Syntax donofdons 1 September 20th, 10:03 AM
Comparing Two Tables sql.bhudev 8 August 23rd, 02:13 PM
Multipul Query's in one single statement sunkara 3 August 13th, 12:10 PM
emp salary sunkara 3 August 11th, 06:14 PM





Solutions


JupiterOnlineMedia

internet.comearthweb.comDevx.commediabistro.comGraphics.com

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info