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?
i think u r sql server is not install properly...bcoz u r querry is absolutely right by prasad
check if the data grid is truncating some part of your resultset.
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
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 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?