http://www.sqlservercentral.com/Articles tagged Administering, SQL-DMO, SQL Server 7, 2000, Configuring posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)How many jobs do you have? 10? 100? 1000? Andy makes the point that what works to manage for a small number of jobs doesn't work when that number doubles or triples (well, unless you only had 1 job to start with!). In part one of two, this article looks at ideas for using categories and naming conventions to get things under control. http://www.sqlservercentral.com/articles/Administering/managingjobspart1/906/2003/01/31http://www.sqlservercentral.com/articles/Administering/managingjobspart1/906/Andy takes a look at the new book on DMO and likes what he sees - "great book for beginner and intermediate DMO users!". We've been supporters of DMO for a while and we're glad to see a new book on the subject. Read the review, add your comments, buy the book! http://www.sqlservercentral.com/articles/Administering/reviewofrealworldsqldmo/842/2002/11/19http://www.sqlservercentral.com/articles/Administering/reviewofrealworldsqldmo/842/Following up on a question posted in our discussion area, Andy looks at how to use DMO to add and remove linked servers. Along the way he points out a couple 'gotchas' and throws in a cool tip about how to save a little time when you experiment with DMO. http://www.sqlservercentral.com/articles/Administering/addinglinkedserversusingsqldmo/801/2002/09/19http://www.sqlservercentral.com/articles/Administering/addinglinkedserversusingsqldmo/801/This week Andy takes a look at a new product from Red-Gate that gives you even more options than you get with their SQL Compare and SQL Data Compare tools - now you can build your own. Add the features you always wanted. Build automated processes instead of using the GUI. It's an interesting product - read the review and then maybe even enter the contest to win a free copy. http://www.sqlservercentral.com/articles/Administering/reviewofsqlcomparisonandsynchronizationtoolkit/580/2002/01/16http://www.sqlservercentral.com/articles/Administering/reviewofsqlcomparisonandsynchronizationtoolkit/580/