Script all Indexes

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Murali » Script all Indexes

32 posts, Page 4 of 4

«««1 2 3 4

Script all Indexes

Rate Topic

Display Mode

Topic Options

Author

Message

Strix

Posted Monday, March 04, 2013 3:58 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 9:07 AM
Points: 5, Visits: 332

I know this is an old post, but I would advise to be very careful with this script.

In bol under indexproperty:
IsPageLockDisallowed
Page-locking value set by the ALLOW_PAGE_LOCKS option of ALTER INDEX.
1 = Page locking is disallowed.
0 = Page locking is allowed.

Script states
IF (INDEXPROPERTY(@idxTableID, @idxname, 'IsPageLockDisallowed') = 1)
SET @sParamSQL = @sParamSQL + ' ALLOW_PAGE_LOCKS = ON, '
ELSE
SET @sParamSQL = @sParamSQL + ' ALLOW_PAGE_LOCKS = OFF, '

This is the oposite and can cause serious performance loss (extra locking).

Post #1426165

Sridhar R Pailla

Posted Thursday, May 02, 2013 4:33 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 17, 2013 9:21 AM
Points: 1, Visits: 42

Thanks for the script it worked perfectly.

Post #1448755

« Prev Topic | Next Topic »

32 posts, Page 4 of 4

«««1 2 3 4

Permissions