For SQL-Server 2000 I would use dts or bcp (bulk copy) to load the data from the csv file into a table in the database.  You can then process the...

Back to your original question, 1) If you don't want to use triggers...

I would do it one of two ways:

a) use triggers and generate the table like you laid out. ...

Here is an article that is an Introduction to SqlServer 2005

http://www.sqlservercentral.com/columnists/fFinney/introductiontosqlserver2005.asp

Steve

If there is no connection, how will they get the scripts you generate to the other locations?

If there is a connection at some time then Snapshot or Merge replication should...

There is an article on this site on 12/07/2004 that compares four backup products and includes the two you asked about.

http://www.sqlservercentral.com/columnists

If you just need a copy of a table in  an Access database, I would just copy from SQL-Server to Access (using dts if SQL-Server 2000). 

Either that, or have...

I support the addresses for our county and we have added zip codes twice in the last 10 years, once because an community wanted their own zip code separate from...

Just a question, Do you have a reason for not setting your tempdb to autogrow?  If you don't have the space I can understand, but if you do have enough...

I daily check the Current Activity and look to see if there are any processes initiatiated by users that are two days old or older based on Last Batch Date/Time.  Usually...

If you are creating the dts from the Import/Export Wizard and have chosen "Copy table(s) and view(s) from the source database", when you select the table(s) click on the Transform...

Enterprise Manager has a nice way of seeing all the indexes on a table.  Choose the database that the table is in and change the View to Taskpad.  Then click on the...

If you want to use DTS, here is a script that should disable triggers and foreign key contraints using the undocumented stored procedure sp_msforeachtable.

-- Disable all constraints and triggers

sp_msforeachtable "ALTER TABLE...

One further thought on the need to store CC information in the customer record.  Do all customers have Credit Cards?  If not, it would be appropriate to put CC information...

Which option did you use for the dts, Copy Tables and Views or Copy Objects and data?  If the table structure hasn't changed, I would think that Copy Tables and...

You could restore to a temporary database and then copy the table from there to the current database.

Steve