im just trying to get some info on this and im getting lots of feedback that is a little confusing.
If i have a simple SP with say 2 nested cursors (dont shout) and all they are doing is building a report table say (not making changes to tables) will the tables opened in these cursors be locked during the operation?
these cursors are running on default settings, no read-only or other settings are used before the cursors.