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
Here is a kb article on SET NO_BROWSETABLE ON:
Let us know if helpful.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?