Index Creation Errors

Question

Post reply

Index Creation Errors

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ned Ten Centuries Points: 1214 More actions · Answer 1

Ned

Ten Centuries

Points: 1214

June 3, 2004 at 4:38 pm

#508910

Can you post your code?

Robert A. Shannon III SSC Veteran Points: 284 More actions · Answer 2

Here is the last line that caused that error (I had to remove specific names, but I assure you I can take the code and paste it into an isql session and all is well):

USE <db_name> CREATE UNIQUE NONCLUSTERED INDEX <index_name> ON <table_name>(<col_1,col_2) WITH SORT_IN_TEMPDB ON <file_group>

This string executed using the EXEC() method and results in the previously specified error. col_2 has a clustered index built on it that builds fine everytime. There are about 32 million rows of data in this table. We are running WIndows 2003 Server, SQL Server 2000.

Thanks!

TTUEagle

Sean Lambert SSC Eights! Points: 845 More actions · Answer 3

While this is not a solution, it may shed some light into the issue and lead you down a path of solving it.

http://support.microsoft.com/default.aspx?scid=kb;en-us;330307&Product=sql2k

Bert De Haes Hall of Fame Points: 3320 More actions · Answer 4

I found the same type of problem on this site http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=113712 and there is a link to a fix ...