Cannot create SIDMAP proc in MASTER DB in SQL 2005

• Express12

  SSCoach

  Points: 18526

  More actions

  April 26, 2007 at 12:08 pm

  #118432

  Is it true we cannot UPDATE System tables in SQL 2005?  Has anyone come up w/ a way to apply SIDMAP changes to a restored DB?

  This code renders useless to allow updates to system tables in SQL 2005:

  USE

  master;

  GO

  EXEC

  sp_configure 'show advanced option', '1';

  EXEC

  sp_configure

  EXEC

  sp_configure 'allow_updates', 1 --;

  RECONFIGURE

  WITH OVERRIDE;

  GO

  EXEC

  sp_configure

  BT

• Aaron Ingold

  SSCrazy Eights

  Points: 9070

  More actions

  April 26, 2007 at 12:22 pm

  #702738

  They're no longer system tables, they're now system catalog views technically.

  If you're trying to remap users, look into sp_change_users_login.