Tag: Microsoft SQL Server

Error 29506 | SQL Server 2005 Management Studio Express

When i binged (yes I’m using bing :P), i found the following fix: Search for Command […]

SQL Server 2005 | Database won’t go Offline

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

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 […]

MS Access 2007 | #Deleted

SQL Server 2005, Access 2007, Access 2003, Microsoft Office Access, #Deleted, error, linked tables

Disable Triggers

Last time, I had some calculation problems in one of my tables, and I needed to make a […]

There is already an open DataReader…

Sometimes, when I try to get data from the SQL Server the following exception is loaded: […]

Get Month Name

In Sql Server to find the month from a date you use the following command: Month(DateTime) […]