sysusers table

• Lotus

  Ten Centuries

  Points: 1170

  More actions

  August 29, 2005 at 3:48 pm

  #165859

  In SQL 2000, in the sysusers table, gid would be the uid of the role to which the user belongs.

   

  In SQL 2005, in the sysusers table, gid is now 0 , though the user belongs a role.

   

  Can someone give some input?

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  September 1, 2005 at 8:30 am

  #586844

  Sorry, no idea exactly what the reason for this is. It could of course be a bug. But remember that the old system tables of SQL Server 2000 are no longer there, the sysusers object (actually sys.sysusers) that you are using is a view that exists for backward compatibility.

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• Lotus

  Ten Centuries

  Points: 1170

  More actions

  September 1, 2005 at 10:54 am

  #586936

  The only reason for now, I want to use this view is that, our product still supports SQL 2000 and SQL 2005.  I do not want to maintain 2 sets of scripts based on the SQL Server 2000.  After we stop supporting SQL 2000, I want to modify the objects to use the new SQL 2005 system objects.

• AFedirko

  Grasshopper

  Points: 19

  More actions

  November 3, 2005 at 7:52 am

  #602138

  I too am looking for a way to support sysusers with SQL 2000 and SQL 2005. Any feedback would be appreciated.