SQL Server Session State woes

Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL server. Please install ASP.NET Session State SQL Server version 2.0 or above.

This error is so misleading. In our current setup, most of the time this error comes up not because SQL Session State isn't installed, but because the user account that is accessing the session state database doesn't have permissions to the sprocs. Quick and dirty fix? Grant that account db_owner on the session state DB.

SSRS Reports in IIS 7

Found out that when you add an SSRS 2005 / 2008 report using the Web Viewer control to a ASP.NET website running under IIS 7 and above that you need to add the ReportViewerWebControl.axd node to both the system.web and system.webServer sections of your web config. If you just add the ReportViewer control to your page, the error message will tell you to add a node into the system.web httpHandlers section. At this point, your report will display, but the page navigation and export controls are disabled.

Adding the node for the ReportViewerWebControl.axd to the system.webServer portion of enables the paging and export controls for your report.

Determine Tables w/o a PK

How to determine which tables in a database do not have a primary key. Needed this for a replication rollout.

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
EXCEPT 
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE CONSTRAINT_TYPE = 'PRIMARY KEY'