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 : 10:16:03
|
| I have a stored procedure which was running fine few minutes ago but not it just breaks and stops right before its about to end.The procedure is inserting data into this table :create table temp_XML(xml_data varchar(8000)) using cursors and row by row operation. The procedure takes about 3 minutes to run and runs fine but just breaks up before its about to end. The last data to be inserted in table is select @feed7 = '</channel>' select @feed8 = '</rss>' insert into temp_XML(xml_data) values (@feed7) insert into temp_XML(xml_data) values (@feed8) This is to close the XML. The proc still runs fine sometimes but breaks most of the times. It was running fine before all the time.I am inserting all the data into column xml_data varchar(8000)Should I use some larger data type for my table if yes any suggestions. |
|
|
sqldev80
Yak Posting Veteran
68 Posts |
Posted - 2006-06-05 : 11:09:52
|
| I just ran a trace and found out that the crusor does reads the last 2 lines and makes the inserts into the tablethen why is the data not acctually inserted into the table. The procedure runs fine on production database and returns more database. But in the development data base there is this problem. Any hints on what maybe going on |
 |
|
|
|
|
|
Stored Procedure breaks and stops - uses cursors