SET_IDENTITY_INSERT ON / All Users are public ?!

Comments

• Options

  bbrown Member Posts: 3,268

  2005-09-04

  What type of access are doing (read, insert, delete, modify)?
  What are you attemping to do?
  
  Does your table have any AutoIncrement fields?

  There are no bugs - only undocumented features.

  0
• Options

  Michael_Schumacher Member Posts: 81

  2005-09-04

  recall wrote:

  can't make all the users admin, and only one can be the owner.

  
  Of course can you make them all the owner
  Just put a Checkmark in the box before DBO where you define database access for the users.
  In the upper window you click in the box of the wanted Database and in the lower window are the roles you can give for this DB.
  public is automatically signed and below that is dbo.

  regards,
  Michael Schumacher
  
  oh, what day is it? Backup day. OK, let's dump all data to /dev/nul ;-)

  0
• Options

  bbrown Member Posts: 3,268

  2005-09-04

  This error occurs because you have defined a field as AutoIncrement and are attempting to insert a non-null value. This is referred to as an identity insert in SQL. The field value is usually supplied by the system but you want the system to accept the value you are supplying.
  
  The only time you would be doing this is either a restore or a dataport. These should be done by a user with sufficient rights. If you are getting this error in daily transactions than you need to review the code.

  There are no bugs - only undocumented features.

  0