79194113

Date: 2024-11-15 22:21:49
Score: 2
Natty:
Report link

It is simple.

  1. Put the table in DESIGN mode
  2. Change the column to had IDENTITY specification
  3. Create a change script
  4. Copy the script and open a query window to paste it into
  5. Run the script

The script will handle creating a temp table, setting the identity insert, dropping the existing table, and renaming the temp table.

Reasons:
  • No code block (0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: Robert