November 2008 Entries

Change Schema for Tables of a Database in SQL Server

 

Run this query against your database, set new_schema as your desired schema, e.g. dbo

exec sp_MSforeachtable "ALTER SCHEMA new_schema TRANSFER ? PRINT '? modified' "

Windows Vista and SharePoint Slow Issue

 

If you are having problems opening documents from your SharePoint site via Windows Vista, then follow the steps given in this post to solve the problem.

Disable Enhanced Security Configuration in Windows Server 2008

 

In order to disable enhanced security configuration of IE 7.0 in Windows Server 2008, go to Server Configurations, then go to Security section of the root pane, choose Configure IE ESC. This way it will work all fine.

Configuring Word 2007 for Use with ASP.NET in Windows Server

 

If you are getting access denied while initiating an instance of the Microsoft.Office.Interop namespace, you simply have to follow this guide to resolve the issue. Actually you are granting launch permission for Office Applications to the accounts you are looking for using the above guide.