I would verify that the connection properties on your troublesome server are set the same as all the rest. In particular, i would look at the timeout parameter and...

Depending on the size of the tables, I made this suggestion once for a seomwhat similar situation.

Using ADO, select the recordset from the source (foxpro), save it in XML format...

If you don't replicate the column to the replication server, I think you're stuck. You could write custom handlers to handle the replicated data and edit it when it's...

See "Shrinking the Transaction Log" in BOL.

you will end up truncating your log and using DBCC ShrinkFile.

Be sure to set autogrow to a reasonable size or turn it off.

Update the data so there are no NULLs in the table

update table set floatcol=0 where floatcol is null

Then use an alter statement to remove change the NULLABILITY

alter table <your table>...

Try

"\t"

Just turning off replication at the server isn't enough. You also need to remove the publications that reference the table. (or is that articles?)

Either way, you have to...

quote:

---

First download the updated SQL BOL for most current information.

---

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

enjoy your 38.5Mb

quote:

---

Our test server had MDAC 2.5 installed and we installed MDAC 2.7 over it. How can we uninstall MDAC 2.7?

---

quote:

---

The best book I've seen so far is http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=528

---

This is pointing to a script. ???

...

This sounds like a bug to me. I'd make sure you have the latest service pack applied. We have an app that repops its catalogs every 1/2 hour...

CDs are notoriously slow to write data to. What are you trying to accomplish? backup? Moving the DB?

If you are just trying to get the data onto...

Turn "autogrow" off for your log file. Your data base activity will stop when the log fills up. You will need to create an automated process to back...

IMO, OODB is a marketing buzzword used by salesmen to confuse management. Ya -- they have a niche place in the market but RDBMS has proven for 20+ years...

Can you use sets and avoid a while loop? I have some processes that insert matching records for tables to keep them synced up. I use a single...