| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 DAO Access Corruption Finder | Other | Intermediate /
Rob Waibel | 8483 since
11/12/2004 3:46:09 PM | Unrated
|
| |
Recently, the IT department found an MSAccess 97 database that would not Compact. I was assigned the task to find out why. |
| |
| |
| |
 |
 Find All Injected Fields In A Database | SQL Server 2000 | Beginner /
Dave Vroman | 7270 since
7/27/2008 7:27:56 PM | Unrated
|
| |
Use this script to identify the tables and fields that may have been injected with problem data.
The active search string is a test to show that it works.
|
| |
| |
| |
|
Is Num | SQL Server 2000 | Intermediate /
Jonathan Spinks | 10226 since
11/14/2003 7:09:17 AM | Unrated
|
| |
The is numeric function can return some weird results isnummeric('.'), isnumeric('+'), isnumeric('-'). Yes, Yes and Yes. These are not the most helpfull results. Heres a little function that tells it like it is. |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
OBJECTPROPERTY (Example: Is Trigger Disabled) | SQL Server 7.0, Other | Advanced /
James Travis | 14068 since
2/4/2002 6:57:07 AM |
By 3 Users
3 Excellent Ratings
|
| |
OBJECTPROPERTY allows you to glean a little more usefully information concerning many aspects of your database. In this example I will demonstrate ho to use it to check if a trigger is in a disabled state or not. (For more options see SQL Books Online). |
| |
| |
| |
|
TSQLINDENTER | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier, Other | Beginner /
Aitor Solozabal Merino | 7180 since
8/21/2006 4:19:08 PM |
By 1 Users
|
| |
STORED PROCEDURE WRITTEN IN T-SQL TO INDENT A T-SQL SOURCE CODE AND SHOW IF THERE IS A DIFFERENCE BETWEEN THE NUMBER OF COMMANDS BEGIN AND COMMANDS END.
ALSO IT SHOWS HOW TO OPEN AND READ A TEXT FILE AND HOW TO WRITE A TEXT FILE IN THE HARD DISK |
| |
| |
| |
|
Writing to Text File | SQL Server 2000 | Intermediate /
Anees Ahmed | 13169 since
6/10/2003 12:50:52 AM |
By 5 Users
2 Excellent Ratings
|
| |
With this Stored procedure you can log messages to a text file |
| |
