| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Handling database file growth | SQL Server 2000, SQL Server 7.0 | Intermediate /
Peter Schmitz | 9383 since
11/14/2002 6:01:26 AM | Unrated
|
| |
Scripts to automatically get notified if a database grew due to the autogrowth option being turned on.
I wrote this after searching all over the web for something like this, but didn't find anything.
Conceptual idea: http://www.sqlmag.com/Articles/Index. ...(description truncated) |
| |
| |
| |
 |
 How to fix bugs in the Live / Production environment | SQL Server 2000, Other | Intermediate /
Himanshu Kumar Sinha | 3360 since
10/20/2005 4:47:48 AM |
By 2 Users
|
| |
This article talks about how to plan the fixing of bugs in Live / Production application |
| |
| |
| |
|
 Info on undocumented DBCC commands.txt | SQL Server 7.0 | Advanced /
Umachandar | 5623 since
7/13/2000 10:19:08 PM |
By 3 Users
2 Excellent Ratings
|
| |
Information on undocumented DBCC commands. Some of these commands will work in SQL60/65 also. These commands are intended for understanding the internal working of the database system while some are purely academic in nature. |
| |
| |
| |
|
Install Informix SE on Caldera Linux | Informix
| Beginner /
Steven Hauser | 3178 since
7/11/2000 10:53:19 PM | Unrated
|
| |
How to install InformixSE on Caldera Open Linux 1.2 Lite |
| |
| |
| |
|
kill a session | Oracle | Advanced /
Andy Archer | 7314 since
11/5/2008 11:33:43 AM |
By 1 Users
|
| |
This small script solicits a username at the SQL*Plus prompt, displays pertinent data (like sid and serial#) for the username's sessions, solicits sid and serial#, then executes an ALTER SYSTEM statement to kill the identified session. |
| |
| |
| |
|
kill all active sessions in a database | SQL Server 2000, SQL Server 7.0 | Intermediate /
harshal mistry | 5134 since
5/28/2004 5:54:06 AM |
By 1 Users
|
| |
Script to kill all the active sessions in a database. |
| |
| |
| |
|
kill all sessions | Oracle | Advanced /
Andy Archer | 2761 since
11/5/2008 11:32:24 AM | Unrated
|
| |
This SQL*Plus script executes a PL/SQL block to kill all sessions except those that you exempt. Handy for getting users off quickly. Loops EXECUTE IMMEDIATE to ALTER SYSTEM for each fetched sid and serial#. |
| |
| |
| |
|
Kill Users in a Particular Database | SQL Server 2000 | Intermediate /
Anees Ahmed | 4317 since
6/5/2003 1:51:00 AM |
By 3 Users
|
| |
This Code basically Kills all the Connections to a particular Database specified. |
| |
| |
| |
|
lock or unlock users with one SQL statement | Oracle | Advanced /
Andy Archer | 5441 since
3/24/2006 4:51:48 PM |
By 4 Users
2 Excellent Ratings
|
| |
When performing maintenance or implementing database/application changes, it is often necessary to keep the users out for a period of time. An easy way to do this is via an ALTER SYSTEM keyin, examined in this write-up. |
| |
| |
| |
|
log on as another user without knowing their password | Oracle | Advanced /
Andy Archer | 10358 since
4/3/2009 9:20:15 AM |
By 5 Users
2 Excellent Ratings
|
| |
This SQL*Plus script provides a means to log on as another user without having to know their password. Useful for troubleshooting when application functionality is mapped to specific users and/or roles. |
| |
