Database schema

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Database schema

Database schema

Rate Topic

Display Mode

Topic Options

Author

Message

kumar99ms

Posted Thursday, August 27, 2009 9:53 PM

Valued 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

Apurva

Posted Thursday, August 27, 2009 10:01 PM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 9:43 PM
Points: 82, Visits: 561

Its a permission issue. Try
Grant Create on schema::myschema to username or rolename.

Post #778880

kumar99ms

Posted Thursday, August 27, 2009 10:53 PM

Valued 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 »

Permissions