Index problems

Question

Index problems

Roman-219231

Grasshopper

Points: 14
More actions
September 18, 2007 at 5:38 pm

#177178

Hi,
I'm pretty new to SQL SERVER 2005 - I'm upgrading from Access projects.
I have several tables in my DB, where each one of course has an index. For some reason, when I create a new record through ASP and want to get the index created by sql server for the new record - i can't do it. I get null value back.
It happens on all tables, and thus I can never get the index value of the just created record - I didn't have this problem right after transfering from Access, and it appeared some time after that, though the code hasn't changed - so i guess the problem is in SQL SERVER and not in my code (which works fine under access).
Can anyone please help me with this one? Why doesn't it give me the index?
Thank you very much.

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

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

Aaron Ingold SSCrazy Eights Points: 9070 More actions · Answer 1

To quote Inigo Montoya in The Princess Bride: You keep using that word. I do not think it means what you think it means.

I think you're talking about something other than an index in SQL Server. Are you talking about an identity column, perhaps?

Roman-219231 Grasshopper Points: 14 More actions · Answer 2

uhhm... I guess so. I took the word from access world - where it is an index. but i guess in MSSQL it isn't...

So yes - I'm talking about an identity column thank you for correcting me.

Aaron Ingold SSCrazy Eights Points: 9070 More actions · Answer 3

No problem. I was just totally confused by your terminology.

What you want to do is set the column to be an identity column first. You can do this through the GUI or by using the ALTER TABLE/ALTER COLUMN syntax. Then you'll need to reset the identity counter by using the DBCC CHECKIDENT command. Checking in Books Online should help you with the syntax for both of those.