it could be but when i did a profiler the only procedure that came up was the check sql server agent has rights procedure and I changed the SA password...

I think it's the security, so I'm going to chekc that

I am. I've deployed the package a couple times just to be sure everything is correct.

The index isn't disabled or hypothetical.

Here are the results of the other columns from sys.indexes:

object_id149575571

nameIX_mms_cs_linkobject_idis_renamed

index_id5

type2

type_descNONCLUSTERED

is_unique0

data_space_id1

ignore_dup_key0

is_primary_key0

is_unique_constraint0

fill_factor0

is_padded0

is_disabled0

is_hypothetical0

allow_row_locks1

allow_page_locks1

has_filter0

filter_definitionNULL

Jeff Moden (4/16/2011)

Did you actually rename the index somewhere along the line? That...

Todd Engen (4/17/2011)

Is that the exact output from sys.indexes, with the case of the...

IndexID Name

0NULL

2IX_mms_cs_linkobjectstateattribrefere

3IX_mms_cs_linkrefereobjectattribstate

4IX_mms_cs_linkobject_idis_deleted

5IX_mms_cs_linkobject_idis_renamed

and the index that is giving me issues is index_id = 5

yes it is but it's giving me the same error. So for this index: ALTER INDEX [IX_mms_cs_linkobject_idis_renamed] ON [dbo].[mms_cs_link] REBUILD, I got this error: Msg 2727, Sev 11, State...

i found the issue to be with running setup.exe. I had to run the individual SQLServer2008SP2-KB2285068-x64-ENU.exe and all the updates ran fine

yup that's where i looked

this only shows information on the install of sql 2008. I've been trying to look for a similar file for the install of SP2 but can't find it. ...

yeah it runs fine. Guess I'll be on the hunt for bad data.

Thanks.

Wish I could give you a specific error. Visual Studio just shuts down saying it encountered an error and asks me if I want to send a report to...

it looks like it's the individual text boxes that are causing the issue. When those are deleted I can see whatever is typed in the body of the report....

no linked servers and no other connections open other than myself