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 |
|
Hinduson
Yak Posting Veteran
69 Posts |
 Posted - 2013-09-20 : 16:47:58
|
| Msg 2760, Level 16, State 1, Line 1The specified schema name "ProductCategory" either does not exist or you do not have permission to use it.Please I get this Error message when I try to Create a table for my project work. My time is limited and i really need help. Too urgent please.Best Regards. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-09-20 : 17:16:29
|
What is the create statement you are using? Posting that would greatly enable someone to provide a useful answer.When you have a statement like shown below, the part shown in red is the schema name. The schema has to exist, and you have to have permission to use the schema.create table xyz.SomeTable(id int, val varchar(32)); |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2013-09-20 : 17:37:22
|
| If I had to guess I'd say that "The specified schema name "ProductCategory" either does not exist or you do not have permission to use it." |
|
|
|
Hinduson
Yak Posting Veteran
69 Posts |
Posted - 2013-09-20 : 19:21:15
|
| The Create Statement is CREATE TABLE ITEMS.ITEMDETAILSBest Regards. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-09-22 : 02:20:57
|
quote:
Originally posted by Hinduson
The Create Statement is CREATE TABLE ITEMS.ITEMDETAILSBest Regards.
then you wont get the above error as the error obvioulsy suggests that you're trying to use ProductCategory schema which you dont have access to.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Querry Problems