Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database schema Expand / Collapse
Author
Message
Posted Thursday, August 27, 2009 9:53 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, November 25, 2009 4:57 PM
Points: 74, Visits: 550
`Hi Every body

CREATE TABLE MySchema.MyTable (col1 int, col2 int)

I getting below error:

Msg 2760, Level 16, State 1, Line 1

The specified schema name "MySchema" either does not exist or you do not have permission to use it.


Could you any body suggest me how can slove this prob

Really appriciated those guys.

Regards
Post #778879
Posted Thursday, August 27, 2009 10:01 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, December 05, 2013 12:31 PM
Points: 82, Visits: 567
Its a permission issue. Try
Grant Create on schema::myschema to username or rolename.
Post #778880
Posted Thursday, August 27, 2009 10:53 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, November 25, 2009 4:57 PM
Points: 74, Visits: 550
Hi Thank you for your reply

I had done mistake here.

am not create any schema that the reason it will give that error

1st create schema after then

in that one we will create schemas

Once again thank you very much
Post #778887
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse