SQL Server 2005 | Database won’t go Offline

I needed to copy a database from SQL Server 2005. To copy it, you need to put the database offline but sometimes it takes too long to go offline and even fails.

The problem might be that the database would still have active connections. Thus to solve this problem you need to: Read the rest of this entry »

Foxpro | Import table to Excel Error

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

Read the rest of this entry »

Published my 100th Post!!!

congratulations

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

I started this blog almost 4 years ago (in 1 month it will be 4 years)… exactly on the 13th of October 2006. At first I wanted to create a blog just to have a blog of my own… but over time, the idea of this blog changed.

I’m a software developer and find many problems regarding development and any other apps needed for everyday use which I manage to solve (ok…. I don’t solve every problem). The ones I solve, I try to post on this blog to be of help to other people finding the same problems.

Each post is concise showing immediately what needs to be done to overcome the error so it doesn’t take up much time to solve it. Anyway, hope I helped some people during these last years.

Also thanks to the WordPress guys for developing this application thus making my blog possible, like many other people!!

Thanks for all the support I received 😉 Happy Reading my Publishings!!

Excel | Print First Row on every page

To be able to print the first row on every page, you need to do the following steps:

Facebook is Down :/

Just tried to access facebook.. but seems to be down.. is it just me or anyone else has this problem?

UPDATE 1: Ok apparently everything is back to normal 😉 Now I can see what you’re doing! 😀

UPDATE 2: But it still seems to be very slow

UPDATE 3: Facebook is down again… You can see for yourself: Read the rest of this entry »

SQL Server 2005 | “Product level is insufficient”

The following error kept popping up when trying to import data from a flat file source of type CSV to be imported in a table in SQL Server:

The product level is insufficient for component source “filename.csv”

To solve this problem, you need to install the Service Pack 2 of SQL Server 2005 from this link.

If you find other solutions… please let me know 😉

Visual Studio | No source code available for the current location

Visual Studio 2005 / 2008

Whilst trying to debug a Stored Procedure, the following error prompted:

There is no source code available for the current location

First you have to make sure that the current user is part of the ‘sysadmin’ Server role (click here for how to).