Jigsaw Blog

22

Jan
2015
0 comments

CrystalDecisions.CrystalReports.Engine.InternalException: Failed to retrieve data from the database

Suddenly started to receive the error CrystalDecisions.CrystalReports.Engine.InternalException: Failed to retrieve data from the database. Details: [Database Vendor Code: 242 ] Failed to retrieve data from the database. read more

15

Oct
2013
0 comments

How to suspend and resume SQL database mirroring

There are times when you need to perform an operation that requires database mirroring to be suspended. A good example is when putting the database into single user mode. read more

25

Sep
2013
0 comments

OLAP or SQL

Today the choice for a business intelligence application is largely perceived as between a Relational and/or Multi-Dimensional databases. Here we explore the differences between the two. read more

24

Oct
2012
0 comments

Generate xsd from NAV Tables

If you need to generate an xsd to represent a NAV table, use the following SQL command read more

24

Nov
2011
0 comments

Enable and Disable Service Broker

How to enable and disable service broker read more

09

Sep
2010
0 comments

Manually register xp_ndo.dll

If you need to manually register the xp_ndo.dll, this is the script I use. read more