Thanks for that.

In the past (many years ago), I was not impressed with Microsoft's Help with Programming Languages and SQL. Ever since, I've used any other resource except for Microsoft....

My personal opinion, BOL is just a reference point, you can't really "learn" how to do things from BOL.

Just to add more confidence, I've worked with more than a thousand tables in a single database and multiple of these databases running on a single server with tables having...

Single DB.

Far too many reasons to elaborate on 🙂

I've found that indexes don't get replicated with SQL Server 2005 Transactional Replication that's set up as a No Sync Publication.

I haven't tested for a Full Sync Publication though.

Does anyone...

However; you have to loop through all of the Subscriptions first and run the sp_DropSubscription for each of the Subscriptions and then run the sp_DropArticle at the end only once...

Hi Brandie, I've been thinking again /* I really got to stop doing that 😉 */

Using the same example of having a varchar(8000) field and only storing 100 bytes on...

🙂 Thanks Brandie, this answers my question.

Does SQL Server actually reserve the space on the disk for the field if it is varchar(8000) and only 100 characters are used?

If the space is not reserved, then later...