CREATE TABLE permission denied in database 'tempdb'

sql-server create-table
Raju picture Raju · Jul 3, 2011 · Viewed 77.9k times · Source

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

CREATE TABLE permission denied in database 'tempdb'.

Why it it? Can anyone help me how to resolve this ?

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]

Thanks Raju

Answer

Phillip Senn picture Phillip Senn · Jun 28, 2012

I went into the database, security, users, right-click on the user, properties. Membership, checked db_owner.

Related questions

How do I create a table based on another table

I want to create a table based on the definition of another table. I'm coming from oracle and I'd normally do this: CREATE TABLE schema.newtable AS SELECT * FROM schema.oldtable; I can't seem to be able to do this …

Read More
C# - Create SQL Server table programmatically

I am trying to create a SQL Server table programmatically. Here is the code. using (SqlConnection con = new SqlConnection(conStr)) { try { // // Open the SqlConnection. // con.Open(); // // The following code uses an SqlCommand based on the SqlConnection. // using (SqlCommand command = new …

Read More
create table from another table in different database in sql server 2005

I have a database "temp" with table "A". I created new database "temp2". I want to copy table "A" from "temp" to a new table in "temp2" . I tried this statement but it says I have incorrect syntax, here is …

Read More