X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Unable To Create An Index, Any Versions    
post Aug 19 2019, 12:28 AM

Posts: 713
Joined: 7-May 11

For some reason when I chose a table and right click on Index I get presented with the dialog in the screenshot, note that it says Add at least one index key column t the index. When I click on add it freezes things up. I have tried on multiple Databases/Tables. Any ideas?

Attached File  Untitled_picture.png ( 309.65K )Number of downloads: 7
Go to the top of the page
post Aug 19 2019, 07:02 AM

Posts: 37
Joined: 17-August 13
From: Ghana

Hi Ordnance1
I don't no what you wanted to achieve, but if you really want to add primary key index to the table you already created in MS SQL Server then try this script.
ALTER TABLE dbo.TableName

see this: SQL CREATE INDEX Statement
Go to the top of the page
post Aug 19 2019, 08:50 AM

UA Admin
Posts: 36,549
Joined: 20-June 02
From: Newcastle, WA

I agree that you can probably script the new index. If so, that'll verify the database and table are okay. And if not, perhaps an error message resulting from that script would help identify the problem.

Also, since you are working in SSMS, you might want to check for configuration that might prevent such changes. Also, verify your login has sufficient permissions on this table to create or alter indexes.

My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    24th January 2020 - 01:03 AM