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 Monday, October 30, 2006 11:02 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Saturday, May 30, 2009 7:45 PM
Points: 192, Visits: 19

Hi,

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

The query looks pretty much like this.

Select * from Table.

It returns some rows , but not all , and then it gives me the following error.

An error occurred while executing batch. Error message is: Couldn't replace text

What does it mean?

Why am I getting it?

Thanks 

 

 




Post #319236
Posted Tuesday, October 31, 2006 4:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, May 12, 2013 12:28 AM
Points: 14, Visits: 95

 

i think u r sql server is not install properly...bcoz u r querry is absolutely right  by prasad

Post #319259
Posted Tuesday, October 31, 2006 4:59 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, November 27, 2013 1:12 AM
Points: 133, Visits: 35

check if the data grid is truncating some part of your resultset.

 



------------
Prakash Sawant

http://psawant.blogspot.com
Post #319260
Posted Tuesday, October 31, 2006 8:31 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 19, 2009 4:02 PM
Points: 223, Visits: 108

Hi,

First of all check how many rows in your table :-

1) USE THE BELOW MENTIONED QUERY FOR IT :

Select count(*)  from table

if you got the output then analyse how many rows are returned to you when you are using the query :

2)  select * from table.

Another alternative of it that you can copy all the records into a temp table using query :

select * into #temp_1 from table

this query will create a temp table with name #temp_1 and then copy all the records into it.

Then use the following query :

Select * from #temp_1

if it shows all the records to you it means the structure or internal links of your table is broken

then you can truncate your main table .

and create a new one form the #temp_1 to load your data.

if you want any help then i am there in between 6.pm to 11 pm at IST.

Thanks & Regards

Amit Gupta..

MCDBA

Post #319315
Posted Tuesday, October 31, 2006 6:12 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Saturday, May 30, 2009 7:45 PM
Points: 192, Visits: 19

Hi,

I have actually tried to select eveything into a temp table. The select into works fine, and if I do a select count(*) there are no problems.

However if I do a select * on either table , the original OR the temp table I get that error.

If I do only a partial select its fine. IE. If I select top 1000 * from Table.

The table contains  a few million rows. So granted it is a lot of information to Select * , but the error message just seems somewhat unrelated to what I'm trying to do.

Unless somewhere in the background SQL actually replaces some text, and runs into an error. 

Do you have any idea, why it would try to replace the text?

Thanks again.




Post #319480
Posted Tuesday, October 31, 2006 6:56 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 9:37 AM
Points: 2,553, Visits: 567
How many columns does your table have - what are the data types ?!







**ASCII stupid question, get a stupid ANSI !!!**
Post #319482
Posted Tuesday, October 31, 2006 7:35 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 9:37 AM
Points: 2,553, Visits: 567
I came across this result in a google search but think the poster is only told to report this to microsoft...it starts off as an out of memory error posting but does deal with the same error as yours' eventually...

Also - you may want to post this in the 2005 forums - you'll have better luck there!!!








**ASCII stupid question, get a stupid ANSI !!!**
Post #319485
Posted Tuesday, October 31, 2006 8:05 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Saturday, May 30, 2009 7:45 PM
Points: 192, Visits: 19

Hi,

Thanks for that.

It definately appears to be what used to show up in SQL 2000 as out of Memory.

I guess I could ask microsoft about it.

I know. Somehow I always manage to post in the wrong place, and then only notice afterwards. Is there no way to just move a post to a differnt category?

 

 




Post #319489
Posted Wednesday, November 1, 2006 4:44 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 9:37 AM
Points: 2,553, Visits: 567
No - there's no way to move a post...but you could edit it and delete everything and provide a link to the new posting instead...good luck and post the results of your findings when you have this resolved!







**ASCII stupid question, get a stupid ANSI !!!**
Post #319544
Posted Tuesday, April 22, 2008 7:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 2, 2008 12:18 AM
Points: 1, Visits: 3
I was getting the same error, so Iopened another management studio session (logged on as the same user etc) and tried the same query and it worked fine. Before, if I tried to return my results in grid format - I got an outofmemory exception - so simply open a new session entirely and retry.
Post #488601
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse