Hi,

I have a multithreaded application where each thread executes a SQL
Query which has same Cursor defined in it.

Suppose if my declared cursor is as below:
e.g. I want to access all the database names. So, I'll create following
cursor:
DECLARE AllDatabaseInfo CURSOR LOCAL FOR SELECT name FROM sysdatabases

Now, If there are two threads executing the SQL Query having above
cursor, then can they access the same table using the same cursor
simultaneously?

Is there any performance issue here?

Thanks in advance,

Regards,
Pramod

Clustered Index Not Working
Stored procedure to change not nulls to nulls
Default Values Question
Learning SQL
Query help