SQL Server Performance Forum – Threads Archive

SQL 2005 NO_BROWSETABLE only with cursors?

Hi all, I’m trying to understand if the "set no_browsetable on" applies only to cursors. As far as I can see, this is done when you don’t want to keep typing "FOR BROWSE" for each of your tables being scanned by a cursor. Is this all it’s used for? I just want to understand the general use of this, nothing detailed. Thanks

KBAs
http://support.microsoft.com/default.aspx?scid=kb;en-us;885146
http://support.microsoft.com/?kbid=886834 Fyi. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Satya, thanks for the quick responce, I read the articles, but they discuss the limitations of the FOR BROWSE and NO_BROWSETABLE statements, not what the statements are actually used for. I think they are used only for application using the sql cursor to select from the database, is that correct?
I’ve never used those, just curious.

Should be moved to 2005 Forums.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

You mention 2005 in the thread title …

Look, a miracle happened to the forum category. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] – Frank Kalis Moderator Microsoft SQL Server MVP Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>

[<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] 1 and half years old thread, whats happening here! Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</center>

Hm – for reasons unbeknownst to men and women alike, this thread popped up on my Active Topics. After the disappearing logins, this is a new one … Let’s hope the new forum software is up and running soon!

That’s because Frank has modified (moved) to relevant forums [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</center>

Then the miracle must be how Frank stumbled across this one. Or are you guys making preparations for the big move, behind the scenes?

Big move is not yet official [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />], may be Frank has too much free time. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</center>

Haha, I have only seen Adriaan’s reply and didn’t even look at the date of the original question. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] – Frank Kalis Moderator Microsoft SQL Server MVP Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>

]]>