Sorry, just noticed that my solution depends on my function dbo.ufn_DelimitedStringToTable.

You can find excellent string splitters on this site with a quick search.

I'm sure one of our resident geniuses can simplify this, but I think this responds to your requirement.

Depends on x_of_y, where x is the 5th element and y is the...

Good one!!! You had me right up until "we'll start to see lots of new refactored code " BWAAA HAHAHA!!!

See Chad Miller's Powershell function Write-DataTable

DECLARE @dDate DATE = '11 Dec 2019'
SELECT DATENAME(DW, @dDate), ((DAY(@dDate)-1) / 7) + 1

• This reply was modified 5 years, 9 months ago by schleep. Reason: Edited to correct formula per Jeff's observation below. (Thanks Jeff)

Try this: (Not sure if this works in 2017, setuser was deprecated, but i'm still on 2008):

setuser 'Domain\UserName';

use <db_name>;

setuser;

If you don't get an error, they have access to the DB...

You can use xp_logininfo 'Domain\Username', 'all' to get some insight into how that user might be getting access to the first db.

One of the items in the permission path column...

OurDomain definitely trusts TheTrustedDomain. And TheTrustedDomain has never trusted ours.

Our workaround is having users start the apps using Run As with their OurDomain creds. But this is not ideal...

In fact, we've pretty much narrowed it down to this one:

https://support.microsoft.com/en-ca/help/4490425/updates-to-tgt-delegation-across-incoming-trusts-in-windows-server

Attempting to digest it, but I'm a DBA, and this stuff quite beyond me :-

Sorry, I was just trying to help and that link sounded like exactly what you were after.

I did not try it, and shares are "discouraged" on our network.

To be honest,...

• This reply was modified 5 years, 11 months ago by schleep. Reason: typo "afer" => "after"

Would this do it?

https://ilovepowershell.com/2012/09/19/create-network-share-with-powershell-3/

Top of the page on DuckDuckGo "powershell create share"

Found the solution.

And Group-Object does come into it:

# Group the objects by table name
$Tables = $array |Group Table

# Select the table name + sum of each group

$Tables...

• This reply was modified 6 years, 1 month ago by schleep.

I don't *think* Group-Object is what I'm looking for: "...a table with one row for each property value and a column that displays the number of items with that value."....

I meant, in Powershell, how can i get the equivalent of

SELECT Table, Col1 = SUM(Col1), Col2 = SUM(Col2)

FROM <$array>

GROUP BY Table

In my example,

Table    Col1    Col2

Table1        4         9

Table2       6        11

I don't see how a trigger helps in this scenario...? If there's no table activity, no trigger is fired, nothing changes...? Or am I standing to close to the tree...