Summary

In this chapter, we've covered how to become compliant with best practices in change management. You can do this by monitoring for change by using DDL triggers. You can also use Visual Studio to create database projects that integrate into Source Safe. The last key for smoothly creating a change-management process is using sqlcmd for a smooth deployment by using command-line scripts. In Chapter 11, you'll learn how to properly configure a server for optimum performance before installing SQL Server 2005.