December 13, 2005 at 10:33 am
When loading a new SQL 2005 database (my first time with SQL 2005), I went ahead and inserted all the data into the unindexed tables first and was then going to add indexes afterward.
Try to do so causes a timeout error every time. The only way I've been able to work around this is to create the indexes prior to loading data. I have gobs of data already loaded and really don't want to go through it again. Besides, I'll be adding new stuff as I go along and will NEED to be able to add an index to existing tables, of course.
Can anyone shed any light on this? I've tried setting the connection properties and everything else one would normally think of.
Thanks,
James Cates
December 13, 2005 at 10:36 am
I forgot to state the error message I am receiving:
- The dialog is labeled "Post-Save Notification"
- Unable to create index '<index name here>'.
Timeout expired. The timeout period elapsed priot to the completion on the operation...
James Cates
December 14, 2005 at 6:53 am
This may be related to "PRB: A Timeout Occurs When a Database Is Automatically Expanding" at http://www.support.microsoft.com/kb/305635/EN-US/
The workaround is to size of the database data file and transaction log appropriately before creating the indicies.
SQL = Scarcely Qualifies as a Language
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply