Problem with creating an index on a large table causes timeout

Category SQL Sub Category Enterprise Manager
Bookmark and Share
If you are performing a long processing operation such as creating an index on a large table, you may find that enterprise manager times out.
To resolve this run the same operation through a query analyser session. You can get the script for the operation you are performing by first:

Carry out the operation in enterprise manager.

Before saving your changes, click the 'Generate change script' icon in the top left of enterprise manager.

This will then give you a script version of your change.

Copy this into query analyser

Do not save your changes from the gui alterations

Run the script from query analyser

Your action will complete correctly.
Share the love
Bookmark and Share