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 |
|
pnpsql
Posting Yak Master
246 Posts |
 Posted - 2012-04-10 : 02:18:44
|
| i have a proc that open a cursor and loop , there are around 5000000 records in he cursor and each record is manipulated in cursor and then insert into another table if they meet condition, i use begin transaction and commit trasaction. because i need if any time the error occured no record need to be manipulate or update. When i execute this Proc and observer that the size of my database is increases. at the point of time the size of disk is full and proc gives me error mesage. plesae suggest..challenge everything |
|
|
vinu.vijayan
Posting Yak Master
227 Posts |
Posted - 2012-04-10 : 05:09:06
|
| Please post the code for your SP. Can't say without having a look at it.Vinu Vijayan |
 |
|
|
|
|
|
database size