How to set set an autoincremntal option

[Mike]

Hi, I use VS2005 and C# and SQL Server Enterprise Manager for MS SQL
Express and i want
to change the column properites for [int]
type of column, but I cann't change it.

More in details...
I'd like to set autoincremntal option and in order to change that I am
trying to change Identity specification from no to yes, without
success.
It is primary key too,
Name AricleID,
int type,
Primary set of binding --> ((0))
Full text specification --> No
Identity specification --> No --> I want to change this

Everything else is disabled

Thanks

 

[Nicholas Paldino [.NET/C# MVP]]

Mike,

How are you trying to change it? Are you trying to use T-SQL, or are
you using the SQL Management Objects (SMO)? If so, can you show the code
you are using to make the change?

 

[Mike]

I am unexperienced with this....

I just want to change it, I do not use any code because I do not know
how Ic an do that. Simply, I am trying to make changes within column
property with MS SQL Server Management Studio Express.

I have very clear idea how to that but I cann't because I cann't
change no to yes . I do not understand why because this filed is not
disabled

If you know any other way how I can change it please teach me, as I
told you, Just want to change it.