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: Continue reading
Tried to import a foxpro table to an excel file but the following errors loaded…
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!!
To be able to print the first row on every page, you need to do the following steps:
- Go to the Page Layout Tab
- Click on the Print Titles under Page Setup. Continue reading
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: Continue reading
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 😉
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).
This morning I found this error when trying to debug a stored procedure from Visual Studio 2005:
User ‘dbo’ could not execute stored procedure ‘master.dbo.sp_enable_sql_debug’
After googling a bit, I found that to solve this problem, the user accessing the DB must be part of the sysadmin server roles. To add a user to this role: (click more for the steps) Continue reading
Next is the code to copy database diagrams from one database to another (tested on SQL Server 2005 and 2008)
DROP TABLE dbo.#tempsysdiagrams
–this will copy your database diagrams into a temporary table
select * into dbo.#tempsysdiagrams from sysdiagrams Continue reading
To convert a string to GUID you have to do the following:
string text = “6937e459-f1bd-4a20-ab10-28ff0010c15b”;
Guid myGuid = new Guid(text);
Happy Converting 🙂