SQL Server Performance Forum – Threads Archive
On Cursors
Hi, Let me know where these cursors are stored while creating.after that where it will place all its datasets and opearte? Pl.give brief storage of cursors. Thanks in advance RegardsSuresh.
Why are you that interested in cursors anyway? There are better ways to get things done in a relational database. Anyway, cursors are not stored separately since they are always part of an SP or a UDF and these objects are stored somewhere in the datafile. It is irrelevant where they are stored exactly. —
Frank
http://www.insidesql.de
http://www.sql-server-performance.com/cursors.asp
quote:Cursors use the tempdb for temporary storage of cursor data.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
try master..syscursors also potentially in tempdb database. see declare cursor in books online
http://www.sql-server-performance.com/ac_undocumented_2000_system_tables.asp more on the cursors cursories. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>