Before the data flow step you can add an Execute SQL step with a DELETE or TRUNCATE TABLE command.

I'm not sure how you could define an identity column with the...

There's not necessarily a one-size-fits-all answer, but I'll try to make some intelligent suggestions for a three-disk server.

Moving the transaction logs for the system databases to the log drive is...

I don't know where this is explicitly stated in the documentation, but I am almost positive the answer is that it can't be done.

A SQL 2000 database backup can be...

Here are some suggestions.

1. Use the ISNUMERIC function to check the addressno column.

SELECT

addressno, addressstreet, addresscity,...

Differential backups are backups of every page in the database that has changed since the last full backup.  If you do a full backup on Sunday and a nightly differential...

A default value will be used in a non-null column if you run an insert that does not include that column.  If you run an insert that is trying to...

The float data type is good for about 15 digits, I doubt very much that there is any chance that some difference out in digit 16 or 17 would produce...

The performance of your server will be greatly affected by the performance of tempdb, so putting it on separate drives (and a separate controller if you have the luxury) is...

I agree with James.  You're proposing that every client suffer a performance hit every day, for ever, just because one merger was a pain.  The extra twelve bytes doesn't sound...

Your single quotes don't match, and I'm not sure whether single quotes would work anyway.

You need to use double quotes.  To use them in an expression you must escape them...

There are a lot of good reasons for declaring fields to match the business need.  Allowing fields to store 2^31 bytes just to avoid worry about overflow is being lazy. ...

Is there some good reason for not using the Surface Area Configuration tool? 

It looks like your sp_configure should work, I tried "sp_configure 'Ad Hoc...

The access for the developers is controlled by SQL permissions, which the DBAs should have control of unless the developers can use a domain login or sa password to cheat. ...

Here is a conversion in T-SQL you could turn into a function.  I'm not sure how you would do it in DTS with ActiveX without the bigint and varbinary data...

I haven't tested this approach, but it might work.  Is the DueDate field meaningful when the status is still "Started"?  If not, you can use a view to show the...