Tag Info

Hot answers tagged

6

The 2012 Books Online topic "Get Information About a View" states that the permissions required for this specific task are: VIEW DEFINITION permission on the database; and SELECT permission on sys.sql_expression_dependencies Note that database-level VIEW DEFINITION is required to allow the user to see information in sys.sql_expression_dependencies; ...


4

I don't think there's a surefire method to find everything. After all, they could have access to things merely by virtue of being in a specific server or database role, or even a Windows AD group (you didn't specify if this is a SQL auth login or a Windows login). There also isn't a surefire way to identify what might break if this is changed - for example, ...


3

From a set of FDs, you can only infer a set of candidate keys. A "primary key" is one particular member of that set of candidate keys that you elect to be "primary". And there are no scientific rules that tell you which one you should choose - you can pick just any key and label it "primary". In your first example, you should end up with a set of ...


2

The mistake is in your understanding of transitive dependency. From wikipedia: Transitive dependency In mathematics, a transitive dependency is a functional dependency which holds by virtue of transitivity. A transitive dependency can occur only in a relation that has three or more attributes. Let A, B, and C designate three distinct attributes (or ...



Only top voted, non community-wiki answers of a minimum length are eligible