Got a SQL DB stuck in restoring?

Then use the following script:

RESTORE DATABASE [DATABASE NAME] WITH RECOVERY

Taken from
http://www.execsql.com/post/bringing-a-database-out-of-restoring-state-in-sql-server-2005

Creating SSRS Reports that fit on to an A4 Sheet

One requirement that always come up when a customer requests a report is that it must print (or export to PDF) onto a sheet of A4.

This is often for summary reports that rollup useful information onto one page, such as an Event's Sessions and Attendees, so that the user can take a copy with them.

The trick to this is to set the report’s page width to 8.27 inches and the height to 11.69 inches.

This tip is taken from a post on Botsikas' Blog, which I have referred to many times!
http://botsikas.blogspot.com/2008/02/sql-reporting-services-and-a4-paper.html

ExecuteNonQuery Error after redeployment

Very useful article just saved me from a day of frustration.

When redeploying an organisation database from a foreign environment, the app pool will not have permission to the new database and must be configured in the SQL database's security settings.

http://www.langalaxy.de/2009/11/system-invalidoperationexception-at-crm-logon/

Rename SQL Server Instance

• For a renamed computer that hosts a default instance of SQL Server, run the following procedures:

  
  

  sp_dropserver  GO sp_addserver , local GO 

  Restart the instance of SQL Server.

• For a renamed computer that hosts a named instance of SQL Server, run the following procedures:

  
  

  sp_dropserver  GO sp_addserver , local GO 

  Restart the instance of SQL Server.

  Then:

  SELECT @@SERVERNAME AS 'Server Name'

  From:

  http://msdn.microsoft.com/en-us/library/ms143799.aspx

Field Level Security White Paper released by Microsoft

Often considered an unsupported customisation to Microsoft CRM 4.0, Microsoft have released a whitepaper detailing the supported methods to secure fields, not entities.

In brief, the document provides consideration to all angles of accessing data, and with forms in mind suggests that designers secure both the field with JavaScript (for accessibility purposes) and through Pre Stage Plug Ins to eradicate non authorised entries by simply removing them from the Propertybag.

You can download the white paper here:
http://download.microsoft.com/download/3/D/9/3D9D0AD7-A6E5-49DC-8963-C0B223250EEF/CRM4%20NB%20-%20SEC%20-%20Field-Level%20Security.pdf
(The googled link appears to be down..)

Email Router logging unresolved Email Addresses

If you are receiving too many errors in the Event Viewer as your Email Router is logging every email that it can't resolve, you can change the logging level by:

• Opening regedit on the server where the email router is installed
• Navigating to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSCRMExRouterService
• Changing the LogLevel value from 1 (default) to 2
• Restarting the Email Router Service

SQL Date Formats

Just stumbled across this page listing Date formats and the SQL to produce them, all in a handy table.

Very useful when producing SSRS reports..
http://www.sql-server-helper.com/tips/date-formats.aspx