help autoincrement error

08/03/2013 08:28 @nDroid22#1

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

08/03/2013 20:10 abrasive#2

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. [Only registered and activated users can see links. Click Here To Register...]

08/04/2013 05:33 @nDroid22#3

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. [Only registered and activated users can see links. Click Here To Register...]

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.

09/07/2013 06:47 Autrux#4

#moved

#closed