Comments
Sort by recent activity
Hi Patrick,
Sorry, this isn't supported. We have an outstanding feature request for this on our system and I've added a note to it to say that you would like to see this implemented.
Apologies. / comments
Hi Patrick,
Sorry, this isn't supported. We have an outstanding feature request for this on our system and I've added a note to it to say that you would like to see this implemented.
Apologies.
Hi Russ,
Unfortunately neither RDS nor SQL Server Express are supported (see the limitations section of the requirements page for more details). Sorry. / comments
Hi Russ,
Unfortunately neither RDS nor SQL Server Express are supported (see the limitations section of the requirements page for more details). Sorry.
Sorry to hear that you're having this problem. In SSMS, if you go to the View menu, then into Toolbars, do you see Redgate in the list? If so, make sure that this it is checked.
If you're still having problems, try uninstalling SQL Search and then installing the version from this link - ftp://support.red-gate.com/patches/SQLSearch/14Jun2017/SQLSearch.exe / comments
Sorry to hear that you're having this problem. In SSMS, if you go to the View menu, then into Toolbars, do you see Redgate in the list? If so, make sure that this it is checked.
If you're still hav...
@Progytech That's great to hear! [image] / comments
@Progytech That's great to hear!
That's strange. The logfile says that the uninstall was successful. When you say it hasn't uninstalled it, do you mean that it's just a number of files that are remaining or is everything still in place, i.e. the program is still fully functional?
Thanks. / comments
That's strange. The logfile says that the uninstall was successful. When you say it hasn't uninstalled it, do you mean that it's just a number of files that are remaining or is everything still in ...
Hi @Jonathon_R and @njzagaroli,
I'm sorry to hear that you're experiencing this problem. Can you try uninstalling by running this powershell script and then sending me the resulting logfile? You may want to adjust the logfile path.
This won't fix the problem, but hopefully it will give us more information as to what is going wrong during the uninstall process. $object = Get-WmiObject Win32_Product -Filter "Name='SQL Search 2'"
$guid = $object.IdentifyingNumber
Start-Process -FilePath "msiexec.exe" -ArgumentList "/X $guid /L*VX d:\uninstall\log.txt" -Wait -PassThru
/ comments
Hi @Jonathon_R and @njzagaroli,
I'm sorry to hear that you're experiencing this problem. Can you try uninstalling by running this powershell script and then sending me the resulting logfile? You ma...
No worries! I'm pleased you managed to find the source of the problem! [image] / comments
No worries! I'm pleased you managed to find the source of the problem!
Can you try installing again from this installer?
If that doesn't work, I would try running the installer again, but with logging to see if that provides any clues. You'll need to run it with this command line -
SQLToolbelt.exe log D:\Logs\mylog.txt
Obviously you can change the logfile path to be whatever you want. Once you've got the log, I'd have a look to see if there is anything obviously wrong in there. / comments
Can you try installing again from this installer?
If that doesn't work, I would try running the installer again, but with logging to see if that provides any clues. You'll need to run it with this ...
JDenman wrote: »
Okay that's what I expected. So there's currently no step to actually create the database itself - that's something we'd have to create a custom step for and use before the RedGate deployment step?
Yes, that's correct. / comments
JDenman wrote: »
Okay that's what I expected. So there's currently no step to actually create the database itself - that's something we'd have to create a custom step for and use before the Re...
You could modify your Octopus Deploy deployment process to include a pre-deployment step that creates the database. For instance, you could create a PowerShell script that uses the Invoke-Sqlcmd cmdlet to execute a SQL script on the server. Your SQL script could do something like the following - IF NOT EXISTS (SELECT 1 FROM sys.databases WHERE name = 'myDatabase')
BEGIN
CREATE DATABASE [myDatabase]
--You could also create any filegroups, etc here
END
Does that help? / comments
You could modify your Octopus Deploy deployment process to include a pre-deployment step that creates the database. For instance, you could create a PowerShell script that uses the Invoke-Sqlcmd cm...