Skip to Content
0
Jan 18, 2023 at 11:11 PM

Error 7040 creating a temp table

297 Views

Executing a SQL like this sometimes produces error 7040 (30% executions):

SELECT *

INTO #tmp2

FROM #tmp1

ORDER BY field1, field2;

I attach a image of the ads_err file:

error-7040.png

Somebody can help me with this?

Thanks!

Attachments

error-7040.png (77.3 kB)