What is Msg 2725 in MSSQL??

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.

  1. SQL Server DBA “Interview Questions And Answers”
  2. SQL Azure Interview Questions and Answers Part – 1
  3. SQL Azure Interview Questions and Answers Part – 2
  4. Powershell Interview Questions and Answers

Regards,

Online MSSQL Classes @ http://tuitionaffordable.webstarts.com

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s