To change the NOT NULL constraint on an existing column use thefollowing SQL. To allow null you must use = NULL, to disallownull you must use = 1.update ...
A quick note on upgrading from an Access DB to a SQL DB.I see a lot of people in forums, and support sites for popular ASP Applications I use struggling with a...
This article explains how to share a work table across multiusers. It also address locking strategies.If for example you have to use a reporting Software, like Crystal...
How to backup a remote database directly to the local machine.My company had a server with a nearly-full hard disk. I needed to backup the database but didn't have...
How to backup another PC to the local machine.The following GBAK command will backup a database on another server to the local machine. GBAK -B -user SYSDBA -password...
Here's an email I sent to everyone in my company that deals with InterBase when I found out about this issue. It details how to figure out what the current next value...