http://www.sqlservercentral.com/Content tagged Scripts posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Running short of disk space? One way to solve that is to keep fewer backups on disk, or write a routine that will compress them to conserve space. Or you could try SQLZip, an add in that creates compressed backups. Read the review, see if it's something you should consider! http://www.sqlservercentral.com/articles/Product+Reviews/reviewofsqlzip/664/2002/04/16http://www.sqlservercentral.com/articles/Product+Reviews/reviewofsqlzip/664/In this product review Andy takes a look at Data Compare, the second of three products in the SQL Bundle available from Red-Gate software. It's a very handy program that lets you compare data between two tables and optionally generate sql statements to syncronize the data. An interesting alternative to replication! http://www.sqlservercentral.com/articles/Replication/reviewofdatacomparev151/490/2001/10/31http://www.sqlservercentral.com/articles/Replication/reviewofdatacomparev151/490/This tip will show you how to BCP data out of every table with one command. http://www.sqlservercentral.com/articles/Advanced+Querying/tipbcpalltables/278/2001/06/15http://www.sqlservercentral.com/articles/Advanced+Querying/tipbcpalltables/278/