indexing - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

indexing

Author

Topic

cwtriguns2002
Constraint Violating Yak Guru

272 Posts

Posted - 2007-11-19 : 22:03:17

Hi evryone...

I have a problem on indexing. The field PK_hrSetBenefitsLeave is the primary key of the table "hrSetBenefitsLeave". When i see it on the "Manage Indexes and Keys", the identity name became PK_hrSetBenefitsLeave_1. Everytime i change it to its original name will get me error...and i can't save it.

Error msg on saving :
'hrSetBenefitsLeave' table
- Unable to create index 'PK_hrSetBenefitsLeave'.
There is already an object named 'PK_hrSetBenefitsLeave' in the database.
Could not create constraint. See previous errors.

I tried to check using this query.

Select * from Information_Schema.Columns where column_name = 'PK_hrSetBenefitsLeave'

- it gives me only 1 record

my_comp dbo hrSetBenefitsLeave PK_hrSetBenefitsLeave 1 NULL NO char 5 5 NULL NULL NULL NULL NULL NULL iso_1 NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL

Thanks.
-RON

RON
________________________________________________________________________________________________
"I won't last a day without SQL"

cwtriguns2002
Constraint Violating Yak Guru

272 Posts

Posted - 2007-11-19 : 22:20:33

anybody?

RON
________________________________________________________________________________________________
"I won't last a day without SQL"

cwtriguns2002
Constraint Violating Yak Guru

272 Posts

Posted - 2007-11-19 : 22:32:20

thank u guys for reading my post

i have found the answer...

thanks again.

RON
________________________________________________________________________________________________
"I won't last a day without SQL"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources