How to fix Exception caused by space in text for Powershell form

Question: I'm building a Powershell form GUI utilising the System.Windows.Forms API. I'm getting an error when passing text value back to be processed from a text box defined by : $CommentsTxtBox = New-Object System.Windows.Forms.TextBox Exception calling "ExecuteReader" with "0" argument(s): "Incorrect syntax near 'mytext'." When I then take the space out of the Comments value – i.e change “New Value” to “NewValue” I get the New value generated message. So the space within the text value is generating the error How can I fix? Answer: The quick answer is to place ' ' around the incoming value where you are... Read more →

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 →

How to get powershell System.Data.DataTable row count

Question: i'm working with Powershell System.Data.DataTable to get values from a SQL Server to generate a report for DBAs. the report is sent via email to the DBA team. As part of the email subject - I'd like to add the row count as a summary - so the DBAs don't need to always click into the email - i.e they only need to click in if there is a row count greater than 0. How can I get the row count from System.Data.DataTable ? Answer: When you use the Powershell Powershell System.Data.DataTable , certain properties are available . One... Read more →