I am running the following
INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'SELECT TSQLString, Duration,Reads,Writes,CPU ,RowCounts,StartTime,EndTime,ServerName
select top 10 TSQLString, duration/1000 as Duration, reads, writes, cpu, rowcounts, starttime, endtime,servername
where textdata is not null
order by Reads desc
and relieving the following error
Msg 8152, Level 16, State 10, Line 1
String or binary data would be truncated.
The statement has been terminated.
The offending column is TSQLString - VARCHAR(max)
The data does fit, I can cut & paste it.
( I'm using SQL 2005, SSIS & export wizards are not options available to me)
Thanks in Advance