Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

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



Group: General Forum Members
Last Login: Today @ 11:41 AM
Points: 5,676, Visits: 11,187
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



Group: General Forum Members
Last Login: Yesterday @ 3:01 PM
Points: 118, Visits: 277
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