Need to change all the table schemas at one time? In my case, the default schema in the early run through DB design was the username (i.e. username.tablename) Obviously, this has caused problems down the road. Here’s a fairly simple fix that will work in SQL Server 2005 or SQL Server 2008:exec sp_MSforeachtable “ALTER SCHEMA […]

For help with SQL Server 2008 remote connections, check this link out:How to configure SQL Server 2005 to allow remote connections on Windows Server 2008 (Longhorn) / Windows Vista It looks like it would only be for SQL Server 2005 remote connections, but the second tip worked like a charm for me. The part about […]