Have you tried using DBCC SHRINKFILE? That does allow you to shrink the file smaller than its original size.

Per BOL.. "Use DBCC SHRINKFILE to shrink a file to a size...

Which replication agent are you getting the error from?

You say the tables are identical... are you talking about data and schema?

An extra unique index or additional/different trigger on the subscriber could cause problems.

It doesn't matter what method you use to get the data out (and BCP is about as fast as it gets), they will all have to read the rows into...

Also check the indexes on the before and after databases.

Someone could have dropped an index (or two), which would account for the reduction in size.

I would guess that caching is the answer.

The first time you run BCP, all the rows have to be read into memory from disk.

The second time you run BCP, all...

Derek

I have 3 SQL Server 6.5 books gathering dust in my garage...

The SQL Server 6.5 Performance Tuning and Optimization guide by Ken England

Planning and Building a high performance database by...

Yes, still running/supporting a major system using SQL 2000.

The system uses multiple servers across the world, synchronized with Merge Replication, all containing sensitive data.

The cost of upgrading the SQL...

I know you're not going crazy 🙂

I was searching for the same information a few months ago, which was why I remembered it was in the SQL 2000 documentation.

From BOL for SQL 2000...

0 = Failed

1 = Succeeded

2 = Retry

3 = Canceled

4 = In progress

Doh... I didn't mean updated. I meant "inserted"

The trigger will give you access to 2 pseudo tables... deleted (which contains the contents of the rows before the update) and...

As it stands, your trigger is inserting all rows from the VCTM table that match the criteria into the KWTM table, not just those that have been updated by the...

Are you sure you are running the command against the correct instance of SQL Server?

You haven't specified the -S parameter, so you will be connecting to the default instance...

GilaMonster (2/3/2012)

---

Ian Scarlett (2/3/2012)

---

If someone mentions cardinality in the context of a table, they may be referring to the uniqueness of the values in a data column e.g. an...

I hope you have a decent firewall... you've posted IP address, logon and password in your connection string!!