|
Home > Archive > MS SQL Server > October 2005 > sp_indexoption
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Sohail 2005-10-28, 11:23 am |
| Hi:
I understand that by default sql server using row level locking, however,
you can change this using sp_indexoption for a table. How do I find out the
type of locking is being used on a table, i.e., row and/or page lavel? I
tried to use "exec sp_indexoption 'authors'" but it expects more parameters
and does not give me this information. Any help will be greatly appreciated.
Thanks
| |
| Andrew J. Kelly 2005-10-28, 1:23 pm |
| Take a look at the Indexproperty function in BOL. All indexes will use row
level locking by default unless you do not have proper indexes to allow such
actions.
--
Andrew J. Kelly SQL MVP
"Sohail" <Sohail@discussions.microsoft.com> wrote in message
news:5FB339EC-9973-493F-8D7B- 6A09DCB8D5DE@microso
ft.com...
> Hi:
>
> I understand that by default sql server using row level locking, however,
> you can change this using sp_indexoption for a table. How do I find out
> the
> type of locking is being used on a table, i.e., row and/or page lavel? I
> tried to use "exec sp_indexoption 'authors'" but it expects more
> parameters
> and does not give me this information. Any help will be greatly
> appreciated.
>
> Thanks
>
|
|
|
|
|