Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rock_query
Yak Posting Veteran
55 Posts |
 Posted - 2013-03-28 : 17:30:22
|
| I am using the AdventureWorks2012 database in SQL Server Express on my laptop. I am trying to create a new table. Here is my code:CREATE TABLE Person.ProjMgr ( firstName VARCHAR (25) NULL, middleName VARCHAR (2) NULL, lastname VARCHAR (25) NULL, ID INT NULL, deptID tinyint NULL, productName VARCHAR (50) NULL, City VARCHAR (25) NULL, State VARCHAR (2) NULL, zipCode SMALLINT NULL )Here is the error message:Msg 2760, Level 16, State 1, Line 3The specified schema name "Person" either does not exist or you do not have permission to use it.Yesterday, I have created tables under the "Person" schema with no problem at all. I am trying other schemas in place of the 'Person' schema such as 'Production' and I am still getting the same error.Why am I no longer able to create tables under these schemas now? How do I give myself permission to use any of these schemas? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-03-28 : 17:40:58
|
Are you in the right database?query to find if you have permission to create schemaselect * from fn_my_permissions(NULL, 'DATABASE') where permission_name like '%schema%' |
 |
|
|
Rock_query
Yak Posting Veteran
55 Posts |
|
|
|
|
|
|
|
Msg 2760, Level 16, State 1, Line 3