none
need hep for SET NO_BROWSETABLE ON

    Question

  • Hi All,

     

    I read on net about SET NO_BROWSETABLE ON which is undocumented command.

     

    It really painful for me as it creates so many deadlocks.

     

    One more important thing is that sometimes when I check the property of SPID it shows nothing menas no any command which creates deadlocks which decrease the performance.

     

    so plz anyone know help me

     

    Regards,

     

    Jayehs pavar.

    Monday, September 22, 2008 3:16 PM

All replies

  •  SQLUSA wrote:
     jayesh pavar wrote:

    Hi All,

     

    I read on net about SET NO_BROWSETABLE ON which is undocumented command.

     

     

    Jayesh,

     

    Here is a kb article on SET NO_BROWSETABLE ON:

     

    http://support.microsoft.com/kb/885146

     

    Let us know if helpful.




    Dear,

                The link which u gave which is very much good as technical point of view. I have few questions.

    1.That's true that I'm using unique indexes but with not null. Eventhough I am getting such errors.
    2.And as For Browse Creates temp tables so will it increase any Physical or Logical IO or memory usage?


    Plz suggest me.

    Waiting for your kind reply.
    Tuesday, September 23, 2008 5:20 AM