0

I have this query

CREATE TABLE tempdb..TEMP_DET( DB_ID NUMERIC(5,0)  NOT NULL,
   DB_D VARCHAR(30)  NOT NULL,
   LAN VARCHAR(3) DEFAULT ''N'' NOT NULL)

and I got this error:

Server user id 13 is not a valid user in database 'model'

Does anyone know the reason ?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Moudiz
  • 7,211
  • 22
  • 78
  • 156

1 Answers1

1

Sounds like permissions for your user have been messed up. Double check to make sure you are a member of a group that has permissions in model (public would be the most likely). Also, double check to make sure public is a valid group in model.

Mike Gardner
  • 6,611
  • 5
  • 24
  • 34