Tag Archives: SQL

Export a Database to SQL Script for SQL 2008R2/2012

Posted on May 16, 2012 by chadit

This works in SQL 2008 R2 and higher (so far has worked in express and standard versions) Ever have a Microsoft SQL database in development that you have locked down and you want to move to production, or in my … Continue reading →

Posted in Database | Tagged , | 1 Comment

SQL Server Report Manager page permission errors

Posted on May 10, 2012 by chadit

Because things never work out smoothly.  After deploying my samples reports I went to http://127.0.0.1/Reports to view it and boom was hit with another permission error: User ‘Win7VM\chadit’ does not have required permissions. Verify that sufficient permissions have been granted … Continue reading →

Posted in Database | Tagged , , | Comments Off on SQL Server Report Manager page permission errors

SQL Server Reporting insufficient permission error

Posted on May 10, 2012 by chadit

The past few weeks have been interesting for me.  While I have toyed with existing SQL Server reporting I have never done anything serious with it.  As a typical developer when we do not know something what do we do… … Continue reading →

Posted in Database | Tagged , , | Comments Off on SQL Server Reporting insufficient permission error

Overflow error on SQL/Oracle/DB2 Databases

Posted on December 31, 2009 by chadit

Like OS’s and development frameworks, each database type out there has its own set of error codes when something goes wrong. For calculations/dates and times an Arithmetic Overflow error can be common. Error depending on Database:

Posted in Database | Tagged , , | Comments Off on Overflow error on SQL/Oracle/DB2 Databases