Declare @msg varchar(100)

DECLARE db_cursor CURSOR FOR

SELECT Name FROM Alldatabases

WHERE OBJECT_ID(Name + 'dbo.<tablename>') IS NOT NULL

ORDER BY Name

OPEN wh_cursor

In your post, you had 2 tables, Settings and Employee, so maybe you...

Wow. So simple now.

Still labouring in 2008, our next version is supposed to be 2016, with no set date for that.

I figure I'll be able to start using STRING_AGG sometime...

You say "occasional" errors. For me, this would go into a separate table with a FK to the main table, the error, and the emailed status (and date?)

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, 11 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 6 years, 1 month 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, 3 months ago by schleep.