In SQL Server 2005, is it possible to create a SQL account which can create/edit views and stored procedures, but not create or modify table schemas? If so, how is that done?
Yes, if you have a look at the GRANT Database Permissions page on MSDN, you'll see that there are permissions
CREATE VIEW, and
CREATE PROCEDURE. You just grant those permissions to the principal involved. Alternatively, you could DENY
CREATE TABLE - whichever suited your scenario best.
In addition to what Matt has noted, there is a role called db_ddl_admin. If you grant access through that role to a login, they'll be able to manipulate database objects. You can either grant access through this and then revoke certain behaviors, or just specifically grant access as Matt suggested. Either way works.
No one has followed this question yet.