SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Querry Problems
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Hinduson
Yak Posting Veteran

Ghana
57 Posts

Posted - 09/20/2013 :  16:47:58  Show Profile  Reply with Quote
Msg 2760, Level 16, State 1, Line 1
The 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
Flowing Fount of Yak Knowledge

3704 Posts

Posted - 09/20/2013 :  17:16:29  Show Profile  Reply with Quote
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));
Go to Top of Page

Lamprey
Flowing Fount of Yak Knowledge

4614 Posts

Posted - 09/20/2013 :  17:37:22  Show Profile  Reply with Quote
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."
Go to Top of Page

Hinduson
Yak Posting Veteran

Ghana
57 Posts

Posted - 09/20/2013 :  19:21:15  Show Profile  Reply with Quote
The Create Statement is CREATE TABLE ITEMS.ITEMDETAILS

Best Regards.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 09/22/2013 :  02:20:57  Show Profile  Reply with Quote
quote:
Originally posted by Hinduson

The Create Statement is CREATE TABLE ITEMS.ITEMDETAILS

Best 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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000