There was a problema user was reflecting
http://groups.yahoo.com/group/sqlcon/message/1119
What I did was following steps
1. Divide the count of table into segments for divide
2. Then use the even Odd functionality for smooth looping
3. Use a simple while loop and SET ROWCOUNT functionality for further deletions across table with checkpoint
4. It saved the log swell up and resources moderation of SQL
5.BUt make sure DB is Simple Recovery model as well so that it can curb log growth and also please test the script in UAT rather than Production directly
Verify Errorlog
Hi this is my first post on sql....The below procedure will check the current errorlog(past one hour errorlog will be scanned)for the keyword "error" (you can include your own key word) .. If you run the procedure it will look for keyword error in the past one hour... it will be use full for some […]
2007-09-12 (first published: 2007-05-06)
728 reads