What is Msg 2725 in MSSQL??
Following is the error message that my junior DBA got when he was trying to REBUILD index online.
Msg 2725, Level 16, State 2, Line 1
An online operation cannot be performed for index ‘PK_Indexname’ because the index contains
column ‘xml_column name’ of data type text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml, or large
CLR type. For a non-clustered index, the column could be an include column of the index. For a clustered index, the
column could be any column of the table. If DROP_EXISTING is used, the column could be part of a new or old index. The
operation must be performed offline.
Answer is that you can’t REBUILD INDEX online if there is any column of type text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml, or large CLR type in the table.
INTERVIEW PREPARATION IN 30 MINs – Read Following wires for a quick interview preparation.
- SQL Server DBA “Interview Questions And Answers”
- SQL Azure Interview Questions and Answers Part – 1
- SQL Azure Interview Questions and Answers Part – 2
- Powershell Interview Questions and Answers
Online MSSQL Classes @ http://tuitionaffordable.webstarts.com