How to stop Dialogresult closing your Powershell GUI application

Question: My head has officially exploded. I've been working on a Powershell script which includes creating a power GUI using the System.Windows.Forms.Form api. Part of the GUI includes clicking on a button which generates a Child Form . The Child Form has a DialogResult associated on the OK button - $ChildfOKButton.DialogResult = [System.Windows.Forms.DialogResult]::OK The problem is every time I click the OK button on the Child Form , it not only closes the Child Form - but also closes the Parent Form. This is not the behaviour I'm expecting or require. How can I fix? Answer: In short the fix... Read more →

How to make a Powershell textbox read only

Question: I'm in the process of creating a Powershell form . As part of the Powershell form there are various objects - such as textbox , labels, buttons. As part of the programming logic - I'd like to manage the read or read only - of the textbox. What is the flag to enable\disable the edit of a textbox? Answer: For a Powershell forms where you're using these assembly libraries and instantiating the form , there are flags you can use on the different objects to control their behaviour Add-Type -assembly System.Windows.Forms New-Object System.Windows.Forms.Form For example - if we had... Read more →

How to force a powershell copy-item file copy

Question : I'm attempting to use Powershell copy-item , to copy a file from a remote location onto a local drive. This is the code I'm executing : Copy-Item \\myremotelocation\servers.csv \\mylocaldrive\temp The problem I'm getting is a "denied" type of error: Copy-Item : Access to the path ' \\mylocaldrive\temp\servers.csv ' is denied. At line:1 char:1 + Copy-Item - \\myremotelocation\servers.csv... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : PermissionDenied: (\\myremotelocation...servers.csv:FileInfo) [Copy-Item], Unauthorized AccessException + FullyQualifiedErrorId : CopyFileInfoItemUnauthorizedAccessError,Microsoft.PowerShell.Commands.CopyItemCommand I can copy the file manually i.e outside of the Powershell environment and I am using the same logon for both the Powershell console and the manual... Read more →

How to change current_user to display dbo

Question: Currently when I execute the sql code - SELECT CURRENT_USER , the return is my login name . I'd like to change the result to display dbo , as there are a number of application code which rely on the login name to be dbo. How can I change the recordset to display dbo? Answer: The easiest way to change the SELECT CURRENT_USER - result is to change the privilege to sysadmin. There are more details on select current_user shows dbo . The quick summary is if the current user is a sysadmin privilege , the recordset returns “dbo”,... Read more →

Database compatibility changing to 100 when restoring SQL 2005 to SQL 2017

Question: Don't ask , but I'm restoring some SQL Server 2005 databases onto a SQL Server 2017 - and there is some database compatibility behaviour I was not expecting. When the database is attached to SQL Server 2005 - the database compatibility is 90. But when restored to SQL Server 2017 - the database compatibility is set at 100. Why is this happening? Answer: This is expected behaviour. i.e when changing from a lower version to a higher version - if the database compatibility of the source db is lower than the lowest compatibility of the target SQL Server version... Read more →