hosterposter : SQL Server

Windows Web Server 2008 and SQL Server 2005

Hoster Poster — Wed, 16 Apr 2008 20:35:00 GMT

If you haven't heard, the new Web SKU is a special, low-priced version of Windows that is focused exclusively on Internet-based Web serving. We've added a lot of new features and support for hardware compared to the old Windows 2003 Web edition. For more details about the SKU, check out Bill Staples' blog post at http://blogs.iis.net/bills/archive/2008/04/15/windows-web-server-2008-and-sql-server-2005.aspx . One thing to note is if you want SQL Server 2005 on Web SKU. The installer blocks on Windows Web Server 2008 but we are providing a patch that will allow you to proceed with the installation. Before attempting to install SQL Server 2005, please download and install the patch from the Download Center page found at: SQL Server 2005 Installer...(read more)

SQL Server Management Studio - Limiting views on shared servers

Hoster Poster — Mon, 17 Apr 2006 15:35:00 GMT

Shared servers usually have many databases belonging to different customers, and MS SQL Server Management Studio (SSMS) will display all those databases when used by a valid login to connect to SQL Server 2005. If you seek to change that default behavior, you can do so with a SQL Server 2005 configuration change. Here's how to make the change. Simply revoke View any database from public, on your SQL 2005 servers, and customers of a shared server, will only see their database, provided you've made the customer the owner of the database. An easy way to do this is with the stored procedure sp_changedbowner (Alter Database can be used too) Here's simplistic sample T-SQL that illustrates the procedure to affect the change on SQL 2005...(read more)