Hi all - I'm trying to copy data from one table in my production environment
to a matching table in a test environment. The table has an identity column
and I'm using the following query to copy the data, but keep getting an
error that I must set identity_insert to on in order to execute the query. I
have done this, but must have made some mistake as I still get the error.


This is a SQL2005 SP2 database. Thanks in advance for your help



[code]



set Identity_insert mtest.dbo.svc00300 on

INSERT INTO MTEST.DBO.SVC00300 SELECT

t.equipid, T.SERLNMBR, T.ITEMNMBR,T.REFRENCE, T.VERSION, T.SRLSTAT,
T.INSTDTE,

T.CUSTNMBR, T.ADRSCODE, T.ADDRESS1, T.ADDRESS2, T.CITY, T.STATE, T.ZIP,
T.COUNTRY, T.CNTCPRSN,

T.LSTPMDTE, LSTSRVDTE, T.TECHID, T.TECHID2, T.OFFID, T.SVCAREA, T.TIMEZONE,
T.WARRCDE, T.WARREND,

T.WARRSTART, T.SLRWARR, T.SLRWEND, T.SLRWSTART, T.SLRWEND, T.SLRWSTART,
T.NOTEINDX, T.MTTR,

T.MTBF, T.MTBI, T.LAST_CALC_DATE, T.METERS_1, T.METERS_2, T.METERS_3,
T.METERS_4, T.METERS_5,

T.DAILYS_1, T.DAILYS_2, T.DAILYS_3, T.DAILYS_4, T.DAILYS_5, T.MTBFS_1,
T.MTBFS_2, T.MTBFS_3,

T.MTBFS_4, T.MTBFS_5, T.METER_DELTAS_1, T.METER_DELTAS_2, T.METER_DELTAS_3,
T.METER_DELTAS_4,

T.METER_DELTAS_5, T.SVC_PM_DATE, T.SVC_PM_DAY, T.VENDORID, T.ADDRESS3,
T.USERDEF1, T.USERDEF2,

T.USRDEF03, T.USRDEF04, T.USRDEF05, T.SVC_SERIAL_ID, T.QUANTITY,
T.SVC_ASSET_TAG, T.SHIPPED_DATE,

T.SVC_REGISTER_DATE,t.dex_row_id

FROM TTC.DBO.SVC00300 T



[/code]





If you have any questions or concerns, please let me know them.



Margaret Norkett

Database Administrator

* 864-271-6522 ext 222

* 864-270-2884










MS Sql Server LazyDBA home page