SQL Server® 2005 is an ideal database platform for use in shared and dedicated Web hosting environments.
The SQL Server 2005 Deployment Guidance for Web Hosting Environments provides best practices for configuring SQL Server 2005 to optimize security, tenant isolation, and the performance of your hosted SQL Server 2005 deployment. Sample scripts for provisioning users and databases for use in shared hosting are included.
The User Provisioning section covers:
- User and database provisioning (logins, users, and databases)
- Stored procedure for creating assemblies