help autoincrement error

@nDroid22 · 08/03/2013, 08:28

launch the (SQL Server Management Studio) icon as administrator then Login in sqlserver in admin account "Godz" database55 for the password then

PS_UserData>Tables>dbo.User_Master

design

"Setprimarykey" the UserUID column name then the

Code:

identity specification  yes
(is identity)              yes
identity increment      1
identity seed             1

then save,..

Code:

Saving changes is not permitted. the changes you have made require the following table to be dropped and re-created. you have either make changes to a table that cant be re-created or enabled the option prevent saving that require the table to be re-created.

User_Master

save text file...
if i cancel

Code:

Microsoft SQL server management studio
User canceled out of save dialog
(MS visual database tools)

how to fix this???

and what .netframework need to install in my system?
thanks for advance

abrasive · 08/03/2013, 20:10

When you receive an error message that is not specific to Shaiya, it is nearly guaranteed there have been many others in the past looking for the same solution you are.

@nDroid22 · 08/04/2013, 05:33

Quote:

Originally Posted by abrasive

When you receive an error message that is not specific to Shaiya, it is nearly guaranteed there have been many others in the past looking for the same solution you are.

thanks abrasive..

this is the solution:
To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box.

Autrux · 09/07/2013, 06:47

#moved

#closed