title: CREATE TABLE permission denied in database 'tempdb'
body: <p>First time I installed SQL Server Management Studio Express and Visual Studio 2005 on my system. Now I am trying to create table by using below script. But if once I execute I am facing error like  </p>
  
  <blockquote>
    <p>CREATE TABLE permission denied in
    database 'tempdb'.</p>
  </blockquote>
  
  <p>Why it it? Can anyone help me how to resolve this ?</p>
  
  <pre><code>USE [tempdb]
  GO
  
  SET ANSI_NULLS ON
  SET QUOTED_IDENTIFIER ON
  GO
  
  CREATE TABLE [dbo].[Employee]
  ([FirstName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
   [LastName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
  ) ON [PRIMARY]
  </code></pre>
  
  <p>Thanks
  Raju</p>