Trying to copy live data from live SQL server to a development server. Tried DTS and simple Insert/Select statement. But having problems with one of the tables. There seems to be a simple linked server meta data problem. For example on running select top 10 * from live SQL server.database.dbo.tablename on development server, I get the error..... OLE DB provider SQLOLEDB supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time. But other tables link ok. Can someone please help Thanks in Advance.