Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Couldn''t replace text Expand / Collapse
Author
Message
Posted Tuesday, April 22, 2008 4:24 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 7:10 PM
Points: 4,576, Visits: 8,349
Superchick (10/30/2006)

I am new to SQL 2005. And I am doing a straigth select from a table.

You're doing select into where?

There must be type mismatch between source and destination.
Post #488978
Posted Thursday, October 31, 2013 10:01 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 12:52 PM
Points: 117, Visits: 217
Had the same error In 2005. Moved the query to 2008 and ran again. Error did not recur.
Mine returned 4.9 million rows, so I have to believe it is some form of "Out Of Memory" error in 2005.

Hope that helps.


<>
Post #1510296
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse