Yes, that's correct, they're fired by AD group policy.

So yes, I don't think the .cmds are called in the users' context. In fact, they would likely be running under a...

"...just create a desktop shortcut to the file in the prohibited folder?"

I'm sorry, I don't follow.

The logon/logoff.cmd files called by the policy are sitting on the SQL Server in...

Nope. I had apparently stumbled upon the correct control, GroupBox, but had not been able to make it work then, but it's working now...

P

Thanks Gaz, that's got it!

How about a try-catch around the first step. Set a variable indicating success or failure, then do step 2, and then throw that variable?

Hi Gaz,

I'm doing this in PowerGUI, BTW.

I guess strictly speaking it's more of a .net / Windows forms question, but I am doing this all in PoSh.

I've replaced a...

OK... Does it work for all the users that are members of that group?

If it does, then it's not access to database xxxxx that's the problem.

Does the sproc perhaps try...

What happens when you try

setuser 'domain\member of group'

go

use xxxx

go

setuser

go

execute as login = 'domain\member of group';

go

use xxxx

go

revert

go

Here's some feedback:

I've found that the code below is considerably faster than my previous RBAR-CBAC solution -- although I think that's what's happening in the background of the where clause.

$Rows...

Thanks again Andy,

I had arrived at the same solution: a VBA function to, er, highlight the rows of interest.

Fortunately this is an ad-hoc type job that only needs to be...

Thanks Andy.

I had a look at the closed XML thing, seems rather complex for my needs.

Let me get down to specifics: I have a worksheet object, got the range...

I'm doing this in a loop: it's taking about .5 seconds/row to access these cells, + another .5 seconds for processing.

$nId = $UserWorksheet.Cells.Item($intRow, 1)

$cE_Description= $UserWorksheet.Cells.Item($intRow, 2)

$cF_Description = $UserWorksheet.Cells.Item($intRow, 3)

$nParent_Id= $UserWorksheet.Cells.Item($intRow,...

Yup, got it. Was not getting any values for Date because column name had a trailing space.

Thanks Bruce.

We only have 1-way trust. The SQL Server domain trusts the outside domain.

AD admin says groups from outside domain could not be members of local groups.

We have a working solution...

Something like this?

foreach ($CurrentlyProcessingDB in $MyListOfDBs)

{

if ($ListOfDbsToIgnore -notcontains $CurrentlyProcessingDB)

{

...