Error in Disallow page locking for tables

[Former Member]

Hi ,

Windows 2003 Enterprise  Server,

SQL SERVER 2008 R2

ECC EHP4.

In analyzing the document EWA was told to disable the page lock for some tables: COVREF, D010INC, REPOLOAD, REPOSRC, TRFCQIN, TRFCQOUT.

I tried running the commands below without success in two ways:

EXEC sp_indexoption COVREF, "DisAllowPageLocks", "TRUE"

Msg 15388, Level 11, State 1, Procedure sp_indexoption, Line 128

There is no user table matching the input name 'COVREF' in the current database or not you have the permission to access the table.

ALTER INDEX ALL SET on COVREF (ALLOW_PAGE_LOCKS = OFF)

Msg 1088, Level 16, State 9, Line 1

Can not find the object "COVREF" because it does not exist or you have not the permissions.

any idea ?

best regards

[Former Member · Accepted solution]

Hi,

I'm putting below the correct sintaxe :

ex: EXEC sp_indexoption [prd.COVREF], "DisAllowPageLocks", "TRUE

tks

[Former Member · Accepted solution]

Dear,

for example you can use this query:

EXEC sp_indexoption 'wcl.REPOSRC', 'DisAllowPageLocks', TRUE

You'll get this exit: Command(s) completed successfully.

Regards

[former_member188883]

Hi,

Could you add the table owner before the table name to have proper identification and access while running the sql commands.

For eg:

EXEC sp_indexoption <schema>.COVREF, "DisAllowPageLocks", "TRUE"

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

I had already tried this way, tks

[former_member188883]

Hi Emerson,

Please try this command and check the results.

ALTER INDEX < Index name >  ON   < Table Name >

SET (

    ALLOW_PAGE_LOCKS = ON

)

GO

Regards,

Deepak Kori

[former_member188883]

Additionally you may check SAP note Note 1458060 - Corrections for MSSQL sessions in ST_SER 701_2010_1 SP02.

See if this is useful.

Regards,

Deepak Kori