Hi All,
i am using mssql 2005 and i am facing a strange problem.
i have two databases A , B.When i try to insert one row in A from my application it is inserting the row but after that it is giving page not found exception when i try to retrieve the data to display form the same table.
When i do the same operation on B from my applciation it is not throwing any error.
1)Is it to do with the lock...
ramyareddy
Last Activity: Nov 20 '07, 08:31 AM
Joined: Oct 25 '06
Location:
-
ramyareddy replied to how to change an existing table column to autoincrement with out affecting the datain SQL ServerHi,
The column is already there in the table. Only thing i have to do is make it auto increment by running some script.
Ittried with this alter table memberSecurity alter column secNo int IDENTITY(1,1)
it is giving error Incorrect syntax near the keyword 'IDENTITY'.
Please tell me where i am wrong, i want to do this by running some script, not from enterprise manager.
Thanks,... -
ramyareddy replied to how to change an existing table column to autoincrement with out affecting the datain SQL ServerHi,
I CAN DO THAT, but i want query so that i can run it from query analyser.
any ideas.....
RamyaLeave a comment:
-
ramyareddy started a topic how to change an existing table column to autoincrement with out affecting the datain SQL Serverhow to change an existing table column to autoincrement with out affecting the data
Hi All,
I am using MSSQL 2000 and 2005.
i have a table memberSecurity with security numer as primary key.
I have some data in the table already.
Now i want to make secNo as auto increment and primary key with out affecting the existing data.
Is there any script that i can run for this?
Thanks,
Ramya
No activity results to display
Leave a comment: