Comments
Sort by recent activity
I'm glad that it worked. / comments
I'm glad that it worked.
There is one reason that I'm aware of that might be causing the slow startup issue. We use a DevExpress component that searches printers as we're loading up. I've seen a couple of cases where orphaned printers, drivers etc have caused this issue.
However to be certain we could benefit from having a log of the startup to see if there's anything odd that we can notice. You can produce a log using FileMon from SysInternals. You can download this from http://www.microsoft.com/technet/sysint ... lemon.mspx
If you can run this application and then start up SQL Compare 6, FileMon will log the actions that SQL Compare is carrying out. Once SQL Compare has finally started up click File > Capture Events to stop the event capture. Click the filter button and type redgate.* into the Include: box. This will leave us with just the entries for SQL Compare. Could you then save the file and send it to support@red-gate.com We'll have a look through to see what we can find. / comments
There is one reason that I'm aware of that might be causing the slow startup issue. We use a DevExpress component that searches printers as we're loading up. I've seen a couple of cases where orpha...
Thank you for your feedback. I've logged this as a feature request and we will consider implementing this in a future version of SQL Prompt. / comments
Thank you for your feedback. I've logged this as a feature request and we will consider implementing this in a future version of SQL Prompt.
I've added this issue to our bug tracking software. This will be looked at when development begins on the next version of SQL Prompt. / comments
I've added this issue to our bug tracking software. This will be looked at when development begins on the next version of SQL Prompt.
These are features that we'd need to add to the software. I've added them as feature requests. The developers will consider adding this functionality when they begin work on the next version of SQL Compare. / comments
These are features that we'd need to add to the software. I've added them as feature requests. The developers will consider adding this functionality when they begin work on the next version of SQL...
You will be able to do this using the SQL Toolkit. However this will require you to write your own small application.
Have a look through the online SQL Toolkit help file. Especially the sample API section which includes sample code for saving a snapshot. http://help.red-gate.com/help/SQLCompar ... frame.html / comments
You will be able to do this using the SQL Toolkit. However this will require you to write your own small application.
Have a look through the online SQL Toolkit help file. Especially the sample API...
SQL Prompt 3.x needs MDAC 2.8 or later. If you don't have this installed then the installer will try to download it, if there are any issues downloading it then you will get the error message that you saw.
You can download MDAC 2.8 from the Microsoft web site. If you have an issue with this where the installer of MDAC complains that you already have it installed then you might like to look at the following forum post - http://www.red-gate.com/messageboard/vi ... php?t=2492
I hope that this helps. / comments
SQL Prompt 3.x needs MDAC 2.8 or later. If you don't have this installed then the installer will try to download it, if there are any issues downloading it then you will get the error message that ...
I am looking into this issue at the moment. I'll let you know as soon as I find anything out. / comments
I am looking into this issue at the moment. I'll let you know as soon as I find anything out.
Could you let me know the exact error message that you're getting? We're aware that occasionally the tools fail to load and you will need to register the add-in manually.
Could you look at the following knowledge base article and let me know if it relates to your issue? http://www.red-gate.com/support/kb/KB200702000008.htm / comments
Could you let me know the exact error message that you're getting? We're aware that occasionally the tools fail to load and you will need to register the add-in manually.
Could you look at the foll...
I've looked into this and to further our conversation. The conflicting schedules in the GUI are just warnings and the backups should still run. The warning is there to let you know that two jobs will be running at the same time which could possibly cause issues. For example if the jobs are both trying to update the msdb database then there's the possibility of locks. To clarify, you aren't able to run multiple jobs on the same database at the same time but you'll be able to run different database jobs concurrently. So, yes, as you're running t-log backups on 60 different databases you should be able to run the job split into two jobs at the same time.
I think that the issue is not the warnings that you get, it is the fact that the job isn't running at all. When you split the job into two can you just schedule one job, on it's own, to run successfully? If so what happens when you offset the second job, say by 15 mins? Does this then cause the jobs not to run? / comments
I've looked into this and to further our conversation. The conflicting schedules in the GUI are just warnings and the backups should still run. The warning is there to let you know that two jobs wi...