Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqldev80
Yak Posting Veteran
68 Posts |
 Posted - 2006-06-05 : 12:12:51
|
| The procedure is inserting data into this table : create table temp_XML (xml_data varchar(8000)) I ran the trace and proc is running fine. But all the data is not returned when I do select * from temp_xml. I did some research and limited data by using a where clause.The proc ran fine. But the proc runs fine in production.I have different procs like this and some run fine in development and not in production and vice versa. The procs have successfully ran in the development before also.any sugesstions on how to fix this. |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2006-06-05 : 12:40:45
|
| When you say "...all the data is not returned..." do you mean you are losing rows or do you mean (some of) the values are being truncated?If it's a truncation issue, check the table to confirm the data is getting in there ok. from query analyzer, make sure the results will return 8000 characters (tools | options | Results tab | Maximum characters per column) then select the value for 1 suspect row.EDIT:If the complete data is not getting into the table...how are performing the insert? through a parameterized SP? Is the input variable large enough?Be One with the OptimizerTG |
 |
|
|
sqldev80
Yak Posting Veteran
68 Posts |
Posted - 2006-06-05 : 14:03:18
|
| I am losing rows. All the rows are not returned even though the trace shows that all the inserts were done. The table has about 20,000 rows. But when I limit the data by using the where cluase then also the table retunrs upto 5,000 rows in some case.The data is not getting into the table in one database but is in another database I am removing all where cluases and get upto 400,000 rows in it. I think the input variables are large enough.Is there any other way to fix this. Is this a memeory issue. |
|
|
|
|
|
|
problem with inserting data into table