[troyb408]

I've pulled my hair out over there error. What am I doing wrong. I've uninstalled and reinstalled a few times and dont know what I'm doing wrong with SQL 2012 just to create a generic table?

TITLE: Microsoft SQL Server Management Studio
------------------------------

Create failed for Database 'GenericDB'. (Microsoft.SqlServer.Smo)


ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262)

[modi123_1]

Yeah.. look at the top left.. it should have a drop down that says "master".. change that to which db silo you want the table to be in.. or right click on said silo and do "new query".

[troyb408]

I'm not seeing that on my top left i have
General
Option
FileGroups

[modi123_1]

Here.. here's where the master context drop down is and here's where you can do the right click and set the context.

[troyb408]

still didnt work said denied in master table


CREATE TABLE permission denied in database 'master'.

[troyb408]

Didnt work screen shot attached

[modi123_1]

What screen shot?

The point is to CHANGE it from Master to your database silo.

[troyb408]

Screen shot not uploading but I did change it from MASTER to TestDB created a table with just two columns first and last name executed and received the same error. I appreciate the help guys

[modi123_1]

Take a screen shot of this happening.

[troyb408]

Shot attached..

Attached image(s)

• 

[modi123_1]

looks like you borked your permissions..


check out this.

http://blogs.amerite...or-account.html

[troyb408]

Thanks I thought when I installed i used the user account in my permissions but guess I didnt. Think I want to uninstall then re install because of a conflicting update.