Month: September 2010

SQL Server 2005 | Database won’t go Offline

I needed to copy a database from SQL Server 2005. To copy it, you need to […]

Foxpro | Import table to Excel Error

Tried to import a foxpro table to an excel file but the following errors loaded…

Published my 100th Post!!!

Just realised that I published my 100th post… which for me is a great feeling. I […]

Excel | Print First Row on every page

To be able to print the first row on every page, you need to do the […]

Facebook is Down :/

Just tried to access facebook.. but seems to be down.. is it just me or anyone […]

SQL Server 2005 | “Product level is insufficient”

The following error kept popping up when trying to import data from a flat file source […]

Visual Studio | No source code available for the current location

Whilst trying to debug a Stored Procedure, the following error prompted: There is no source code […]

Could not execute stored procedure ‘master.dbo.sp_enable_sql_debug’

This morning I found this error when trying to debug a stored procedure from Visual Studio […]

SQL Server 2005 | Copy Database Diagrams

Next is the code to copy database diagrams from one database to another (tested on SQL […]

Convert String to GUID | Quickie

To convert a string to GUID you have to do the following: string text = “6937e459-f1bd-4a20-ab10-28ff0010c15b”; […]