## How to List All Permissions for SQL Server Fixed Database and Server Roles

I am trying to list all current permissions for `db_owner` and `sysadmin` for SQL Server 2012. I found these SPs:

``EXEC sp_srvrolepermission 'securityadmin' EXEC sp_dbfixedrolepermission 'db_owner' ``

However, these are deprecated and only accurate as of SQL Server 2000. Is there an equivalent mechanism to accomplish the same thing today?

## How to Flatten a list to use the inner lists inside Sum

I have the following list:

``list = {{i,0,2},{j,0,2}}; ``

I want to use the sub-lists into `Sum` as

``sum = Sum[a[i]*b[j],{i,0,2},{j,0,2}] ``

I need to Flatten the list to get access to its all nested-sublists.

## Shopper Mailing List – A Smart Buying Guide

With a great many organizations giving buyer mailing list administrations it is overwhelming to pick the most important and deals driven mailing list. You should zero in on the particular subtleties and characterize the market you have to target and will be keen on your items. An accomplished mailing list organization having years long practices to take into account customers who focus on the comparative gathering of purchasers of yours. In the event that the organization can arrive at the clients that you have to get to it can convey you the buyer subtleties you try to do your mission. Search for the tributes and criticism from those past clients the organization. The degree of fulfillment of existing clients will imply you the presentation of the organization and execution the email list in your overview or advertising effort. For more information visit consumer phone list

While searching for a shopper list, there are a few variables and realities about the rundown you should make sure to abstain from committing an expensive error and cost accomplishment of your mission. These are – For more information visit consumer phone list

## Recursively plotting specific elements in a list of lists

I am trying to build band structures and am looking to generate a general code that will work regardless of my list size. Here is what I am trying to do: say I have a list like

``list = {{0.0, 1, 2, 3}, {0.1, 4, 5, 6}, {0.2, 7, 8, 9}, {0.3, 10, 11, 12}}; ``

and I want to plot the nth element of each list against the first element of each list. How can I tell Mathematica to automatically produce a set of lists to plot like shown below

``k = {0.0, 0.1, 0.2, 0.3}; band1 = {1, 4, 7, 10}; band2 = {2, 5, 8, 11}; band3 = {3, 6, 9, 12}; Show[ListLinePlot[k, band1], ListLinePlot[k, band2], ListLinePlot[k, band3]] ``

Doing it manually one band at a time is possible but a waste of time when I have n=36+ bands. Any help would be much appreciated!

## what is the difference from these two places? Import own publishing resource list

what is the difference from these two places? Import own publishing resource list

## Plotting data from a list of rules, infer axis titles from the rules with units

I have data, with units, organized as a list of rules; this is so I can slice the data in different ways based on the variables represented.

I’m trying to find the most direct way to plot this and get axis titles with both the variable from the rule and unit from the values. I don’t want to manually label the plots each time, so if Plot doesn’t have a built-in then how can I write a function to do the inference? I’m looking for the most DRY approach possible.

This gives me the units, but not the variable names, in the labels:

``data = {    y -> {0, 33.2} (Quantity[1, ("KipsForce")/("Inches")^2]),    x -> {0, 6} 10^-4    }; ListLinePlot[Transpose@({x, y} /. data), AxesLabel -> Automatic] ``

On the same example, is it possible to retain units like "in/in"? I’ve done this by manually specifying the labels and using `HoldForm` to avoid evaluating the cancellation, but I can’t get that to work with automatic labels as above.

## How to calculate Sum of a function over a list

`tlist = Table[i, {i, 1, 10}]`

tlist:{1, 2, 3, 4, 5, 6, 7, 8, 9, 10}

`f = E^(-((2 t)/T));`

`Sum[f, {t, {tlist[[i]], {i, 1, 8}}}]`

How to calculate Sum of a function over a list?

One way to do this is by defining `f[t_]:= E^(-((2 t)/T));` Is there a way to do it in any other manner. Because I have to do this for various functions with a higher level of complexity.

## In doubly connected edge list how to link halfedges properly

I’m working on doubly connected edge list. In the image below I need to add a new edge (consisting of halfedges $$g$$ and $$h$$). When adding a new edge we need to assign each half edge a previous and next half edges. In this example edge $$g$$ would have halfedge $$f$$ and $$h$$ as previous and next halfedges respectively. And edge $$h$$ would have halfedge $$g$$ and $$a$$ as previous and next halfedges respectively. If we ignore for a second them being linked to each other, $$g$$ and $$h$$ are linked to the pair $$f$$ and $$a$$. I hope this makes sense. My question is when adding a new edge, how do we know how to choose the correct pair to link to? In this example we could link our halfedges to the pair $$a, f$$ or $$c,b$$, or $$e,d$$. Do we have to resort to linear algebra, doing cross/dot product calculations to calculate what pair of halfedges to choose, based on the geometry of the edges? Am I possibly going in the completely wrong direction?

To get the potential canditates of pair of halfedges to link to, I iterate through all halfedges linked to vertex $$v$$, which here would be $$a,c,e$$ and for each I find the previous halfedge which would $$f, b,d$$ respectively.

## Does the Aberrant Dragonmark Feat add the Sorcerer spell to your Sorcerer spell list?

I’m playing a Wild magic sorcerer and it occurred to me that this feat could potentially add a spell to my sorcerer spell list (to proc wildmagic), but is it fully considered as such and can I use my other spell slots / pact slots freely to cast these spells learnt by this feat?