SQL Server 2008 R2 Data Export Problems

sql, sql-server, sql-server-2008-r2

Solution

All I had to do was:

- Right-click on the column (in this case 'ID')

- Select Modify

- Inside the Column Properties scroll down until you see Identity Specification

- Expand the view and select NO from the drop down menu.

If anyone knows a different (faster) way of doing this please share

Problem

I am trying to export data from my production DB to my development DB but I am getting this error: Messages Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column "id". (SQL Server Import and Export Wizard) Is there a way to check which column is that because I have 20 tables that all of them use the column name `id` or at least get a better error report?

Original source