DECLARE @indexName nvarchar(128) DECLARE @dropIndexSql nvarchar(4000) DECLARE @Constraint_Name nvarchar(128) DECLARE @SQL varchar(4000) DECLARE @Message varchar(400) Raiserror('Creating index combo IndexCombo1...',0,1) With Nowait BEGIN TRY IF NOT EXISTS (SELECT * FROM sys.filegroups WHERE Name='Reply') ALTER DATABASE UniversalThread ADD FILEGROUP Reply IF NOT EXISTS (SELECT * FROM sysfiles WHERE Name='Reply') ALTER DATABASE UniversalThread ADD FILE (Name='Reply',FileName='d:\Data\Universal Thread\Reply.ndf') To FileGroup Reply CREATE INDEX [IndexCombo1] ON [Reply] ([NoMember]) INCLUDE ([NoThread]) ON [Reply] END TRY BEGIN CATCH Raiserror('Error: Problem creating index combo IndexCombo1...',0,1) With Nowait SET @Message=ERROR_MESSAGE() Raiserror(@Message,0,1) With Nowait END CATCH Raiserror('Creating index combo IndexCombo2...',0,1) With Nowait BEGIN TRY IF NOT EXISTS (SELECT * FROM sys.filegroups WHERE Name='Reply') ALTER DATABASE UniversalThread ADD FILEGROUP Reply IF NOT EXISTS (SELECT * FROM sysfiles WHERE Name='Reply') ALTER DATABASE UniversalThread ADD FILE (Name='Reply',FileName='d:\Data\Universal Thread\Reply.ndf') To FileGroup Reply CREATE INDEX [IndexCombo2] ON [Reply] ([NoMember],[Read]) INCLUDE ([NoThread]) ON [Reply] END TRY BEGIN CATCH Raiserror('Error: Problem creating index combo IndexCombo2...',0,1) With Nowait SET @Message=ERROR_MESSAGE() Raiserror(@Message,0,1) With Nowait END CATCHThere has to be something that caused this. I cannot imagine that SQL Server would have a bug in there.