Well I assume by the output that you are doing this through an external application, not Enterprise Manager or Query Analyzer.  My first suggestion is to run the sp_attach_db command...

What are you connecting with? Query Analyzer, Enterprise Manager, Other Application with ODBC, etc? What protocols (TCP, Named Pipes, etc) are you using on the server?

James.

"The problem occurs because Microsoft Distributed Transaction Coordinator (MS DTC) is not configured for network access. By default, the network access settings of MS DTC are disabled on new installations...

I'm not seeing the bit map you posted.  Try just copying the text error message and posting that.

They are not a replacement for ZIP Codes.  FIPS (Federal Information Processing Standards) are US Government standards for specific types of data and data processing.  Codes from this standard (

Actually truncate table is logged, it just the deallocation of the pages that are logged rather than each row, and that can be undone within a transaction.

If you try the...

This depends on the table design (i.e. foreign keys, etc) but I would (first backup the database) copy the 100K records into a new table:

select * into #t1 from yourtable...

What, if any, error message do you get?  Exactly how are you trying to move the databases, what command is failing.  Post the actual command that is failing (include all...

Ok, I readjusted my original code to use UPDATETEXT you should be able to take it from there. 

While I don't understand all your requirements (obviously) this seems like a...

What is the constraint?  (constraint fk_constrname foreign key (colname) references parenttablename (colname) [on update cascade] [on delete cascade]

If you don't have a constraint then its only an implied foreign key...

The alternatives to "Cascade Delete" is to manually delete the child record(s) before deleting the parent.  I often use this in Data Warehouses when I want to insure the person...

Not sure I'm following exactly what you want to do, but it sounds like you could still use the code I posted earlier.  Inside the While loop, just before the...

Phil is correct, be careful what you delete, just because it's not being used now doesn't mean there isn't an appliction out there depending on it.  It's a real bummer...

Hmm, are we still working the same inventory problem?  Post the DDL (definition) for the FactInventoryTrx table, and your DateTime table, along with some test data (three or four records)...

--See if you can use the following example code to accomplish what you want

--If the "replace" command doesn't work in your circumstances then substitue

--your UPDATETEXT command INSIDE the loop.  Your...