August 27, 2009 at 9:53 pm
`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
August 27, 2009 at 10:01 pm
Its a permission issue. Try
Grant Create on schema::myschema to username or rolename.
August 27, 2009 at 10:53 pm
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply