How can we help you today? How can we help you today?
CraigEddy
Activity overview Badges (0) Posts (10) Comments (26)

Comments

Sort by recent activity
When I attempt to open Tab History, this is the error I'm getting: '{DependencyProperty.UnsetValue}' is not a valid value for property 'OpacityMask'. SSMS: Microsoft SQL Server Management Studio 11.0.5058.0 / comments
  1. Community
  2. SQL Prompt
  3. SSMS 17 crashing post SQL prompt 9 update
When I attempt to open Tab History, this is the error I'm getting:'{DependencyProperty.UnsetValue}' is not a valid value for property 'OpacityMask'.SSMS: Microsoft SQL Server Management Studio 11.0...
0 votes
CraigEddy said: When I attempt to open Tab History, this is the error I'm getting: '{DependencyProperty.UnsetValue}' is not a valid value for property 'OpacityMask'. SSMS: Microsoft SQL Server Management Studio 11.0.5058.0 This is fixed in 9.5.23.12091. Thanks! / comments
  1. Community
  2. SQL Prompt
  3. SSMS 17 crashing post SQL prompt 9 update
CraigEddy said: When I attempt to open Tab History, this is the error I'm getting:'{DependencyProperty.UnsetValue}' is not a valid value for property 'OpacityMask'. SSMS: Microsoft SQL Server...
0 votes
@Tianjiao_Li I was able to get the Web folder deleted by first un-installing IIS Express, then deleting the folder, and then using the installer again. I'll probably pursue using IIS soon, when I find time to get it configured on that machine. Thanks for your help. Craig / comments
  1. Community
  2. Redgate Monitor
  3. Why do I receive "installer has insufficient privileges to access <...>\Website\Download" ?
@Tianjiao_Li I was able to get the Web folder deleted by first un-installing IIS Express, then deleting the folder, and then using the installer again.I'll probably pursue using IIS soon, when I fi...
0 votes
Tianjiao: I'm getting a similar error with SQLMonitorWeb_8.0.17.16240.exe but now it's about the C:\Program Files\Red Gate\SQL Monitor\Web\Website\Scripts folder.  I uninstalled the SQL Monitor Web Services and tried the installer with the same result. / comments
  1. Community
  2. Redgate Monitor
  3. Why do I receive "installer has insufficient privileges to access <...>\Website\Download" ?
Tianjiao: I'm getting a similar error with SQLMonitorWeb_8.0.17.16240.exe but now it's about the C:\Program Files\Red Gate\SQL Monitor\Web\Website\Scripts folder. I uninstalled the SQL Monitor Web ...
0 votes
Yes, that worked like a champ! Thank you! / comments
  1. Community
  2. Redgate Monitor
  3. Why do I receive "installer has insufficient privileges to access <...>\Website\Download" ?
Yes, that worked like a champ! Thank you!
0 votes
Wow! I think version 2.0.23 has fixed this. Thanks!  [image]   / comments
  1. Community
  2. DLM Automation
  3. A parameter cannot be found that matches parameter name 'AbortOnWarningLevel'
Wow! I think version 2.0.23 has fixed this. Thanks!  
0 votes
I'm having a similar issue, but with the following errors. This started today when our on-premise TFS 2018 server updated the DLM Automation Build extensions to 2.0.22: 2018-05-08T18:03:15.1046280Z ##[section]Starting: Build FITDB 2018-05-08T18:03:15.1202541Z ============================================================================== 2018-05-08T18:03:15.1202541Z Task : Redgate DLM Automation 2: Build 2018-05-08T18:03:15.1202541Z Description : Build and test databases with Redgate's DLM Automation 2018-05-08T18:03:15.1202541Z Version : 2.0.22 2018-05-08T18:03:15.1202541Z Author : Redgate Software 2018-05-08T18:03:15.1202541Z Help : [More Information](https://documentation.red-gate.com/display/DLMA2/DLM+Automation+2+documentation) 2018-05-08T18:03:15.1202541Z ============================================================================== 2018-05-08T18:03:16.1223814Z Preparing task execution handler. 2018-05-08T18:03:16.4036276Z Executing the powershell script: C:\agent\_work\_tasks\RedgateDlmAutomationBuild_7345fe1b-d099-46f0-a0d1-7292cd17feee\2.0.22\DlmAutomationBuild.ps1 2018-05-08T18:03:18.6067242Z ##[warning]Could not find any suitable versions of DLMAutomation from any registered PSRepository 2018-05-08T18:03:18.6873505Z ##[error]System.Management.Automation.CmdletInvocationException: A parameter cannot be found that matches parameter name 'MaximumVersion'. ---> System.Management.Automation.ParameterBindingException: A parameter cannot be found that matches parameter name 'MaximumVersion'. 2018-05-08T18:03:18.6873505Z at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception) 2018-05-08T18:03:18.6873505Z at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame) 2018-05-08T18:03:18.6873505Z at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) 2018-05-08T18:03:18.6873505Z at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) 2018-05-08T18:03:18.6873505Z at System.Management.Automation.Interpreter.Interpreter.Run(InterpretedFrame frame) 2018-05-08T18:03:18.6873505Z at System.Management.Automation.Interpreter.LightLambda.RunVoid1[T0](T0 arg0) 2018-05-08T18:03:18.6873505Z at System.Management.Automation.PSScriptCmdlet.RunClause(Action`1 clause, Object dollarUnderbar, Object inputToProcess) 2018-05-08T18:03:18.6873505Z at System.Management.Automation.PSScriptCmdlet.DoEndProcessing() 2018-05-08T18:03:18.6873505Z at System.Management.Automation.CommandProcessorBase.Complete() 2018-05-08T18:03:18.6873505Z --- End of inner exception stack trace --- 2018-05-08T18:03:18.6873505Z at System.Management.Automation.Runspaces.PipelineBase.Invoke(IEnumerable input) 2018-05-08T18:03:18.6873505Z at System.Management.Automation.PowerShell.Worker.ConstructPipelineAndDoWork(Runspace rs, Boolean performSyncInvoke) 2018-05-08T18:03:18.6873505Z at System.Management.Automation.PowerShell.Worker.CreateRunspaceIfNeededAndDoWork(Runspace rsToUse, Boolean isSync) 2018-05-08T18:03:18.6873505Z at System.Management.Automation.PowerShell.CoreInvokeHelper[TInput,TOutput](PSDataCollection`1 input, PSDataCollection`1 output, PSInvocationSettings settings) 2018-05-08T18:03:18.6873505Z at System.Management.Automation.PowerShell.CoreInvoke[TInput,TOutput](PSDataCollection`1 input, PSDataCollection`1 output, PSInvocationSettings settings) 2018-05-08T18:03:18.6873505Z at Microsoft.TeamFoundation.DistributedTask.Handlers.LegacyVSTSPowerShellHost.VSTSPowerShellHost.Main(String[] args) 2018-05-08T18:03:18.7029855Z ##[error]LegacyVSTSPowerShellHost.exe completed with return code: -1. 2018-05-08T18:03:18.7029855Z ##[section]Finishing: Build FITDB / comments
  1. Community
  2. DLM Automation
  3. A parameter cannot be found that matches parameter name 'AbortOnWarningLevel'
I'm having a similar issue, but with the following errors. This started today when our on-premise TFS 2018 server updated the DLM Automation Build extensions to 2.0.22: 2018-05-08T18:03:15.1046280Z...
0 votes
The BAK files were indeed being generated daily, but always overwrite the contents of that folder and named, for example, "FIARPE.BAK" (we actually have three databases which we image/clone and all three exhibited the issue we're seeing). The images were created with the date suffixes in the image names. The FIARPE_20171221.BAK instance was my hope that if we just renamed the source BAK file then we wouldn't see this problem. We definitely confirmed that if we create an image from a particular BAK file, clone it to a server, and check its data that the data was not coming from the source BAK file. However, if we restored that same BAK file directly to a server, the data was indeed current. Thanks, I'll send an email to support. / comments
  1. Community
  2. SQL Clone
  3. Images Seem To Be Being Reused When New Images Are Created
The BAK files were indeed being generated daily, but always overwrite the contents of that folder and named, for example, "FIARPE.BAK" (we actually have three databases which we image/clone and all...
0 votes
You could use the Powershell script above, augmented to write the data into the table of your choice in your SQL Server instance. Just a thought... / comments
  1. Community
  2. SQL Clone
  3. Reporting
You could use the Powershell script above, augmented to write the data into the table of your choice in your SQL Server instance. Just a thought...
0 votes
We are also giving up on using SQL Source Control migration scripts. Constantly running into issues with the scripts taking forever to construct in SQL Compare, if they get generated at all. The most common inexplicable error is something about "2 conflicts prevent checkout" while generating a deployment script in SQL Compare. We have made a heavy investment in time trying to troubleshoot issues with these scripts, all in the hope of one day automating our database deployments. But with so much manual intervention required in order to just get the scripts and their associated files to even be processed by SQL Compare, automation seems impossible. Thanks, Craig Eddy / comments
  1. Community
  2. SQL Source Control
  3. Abandon using migration scripts
We are also giving up on using SQL Source Control migration scripts. Constantly running into issues with the scripts taking forever to construct in SQL Compare, if they get generated at all. The mo...
0 votes
Total activity
51
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
15