SQL Server 2005 introduces a new paradigm for data-definition language (DDL) commands. You'll create all objects by using a CREATE command, remove them with a DROP command, and modify them by using ALTER. SQL Server 2005 won't have separate stored procedures for changing one aspect of an object—like sp_defaultdb in SQL Server 2000 and 7.0, which changes a user's default database—or special single-purpose creation commands such as sp_addtype. SQL Server 2000 started moving in this direction by enhancing the ALTER DATABASE command's functionality to include all changes to database properties, and discouraging the use of the sp_dboption command.

Som...