Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I was reading <a href="http://technet.microsoft.com/en-us/library/cc966507.aspx" rel="nofollow noreferrer">this page</a> and they have an interesting sentence in there:</p> <blockquote> <p>Caution: Be very selective when adding users to these roles. For example, sysadmin maps out to dbo in every database and is the equivalent of logging in using the sa account.</p> </blockquote> <p>Of course, they also have this:</p> <blockquote> <p>Permissions that are granted to users and roles and are database specific. All permissions are cumulative with the exception of a DENY. A denied permission at either a user level or at a role level overrides the same permission granted via other role memberships with the exception of the sysadmin fixed server role. (A sysadmin retains all permissions, even if a role they are a member of has a DENY permission.) </p> </blockquote> <p>So if you're a domain admin and in SQL 'sysadmin' group, the world should be your crustacean.</p> <p>Of course, according to Microsoft, you should be taking a quick look at these two pages:<br> <a href="http://msftdbprodsamples.codeplex.com/wikipage?title=Database%20Prerequisites&amp;referringTitle=Home" rel="nofollow noreferrer">Link to Database Prerequisites</a> </p> <p><a href="http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20Databases&amp;referringTitle=Home" rel="nofollow noreferrer">Link to Installing Databases</a></p> <p>You're being naughty and trying to attach them manually :) Seriously though, do you have all the prerequisites for the AdventureWorks2008 database?<br> I suspect this is just another Microsoft oddity/edge case, but I could be wrong.</p>
    singulars
    1. This table or related slice is empty.
    1. POAccess is denied when attaching a database
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USsudhAnsu63
    1. USTrevoke
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO+1 because your comment helped me to find the answer. I will post my findings to this thread. BTW (I was being "naughty" due to very strange policies where I work -- the adventureworks database is distributed as an exe. I can't download exe's. (I can download zip files and MSI files, so I don't see how the exe filtering really does anythign other than get in the way, but those are the rules). Anyway, I could get the raw mdf files as zips from codeplex, and that's when I ran onto this little curiosity.
      singulars
      1. PO
      1. USJMarsch
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload