Comments
Sort by recent activity
Hi nuberfin,
Could you take a look at the SQL Error log and see if there seems to be any problems with the time? Could you also try cycling the error log and see if that stops it?
You can use this command:
sp_cycle_errorlog
I hope this helps, / comments
Hi nuberfin,
Could you take a look at the SQL Error log and see if there seems to be any problems with the time? Could you also try cycling the error log and see if that stops it?
You can use this...
Hi leedavies,
If it's always the same tables or a few different common table selections have you tried creating different projects for each? You could then just run these projects as needed. Another option could be to use the command line and specify which tables are to be compared. This of course will depend on whether you need to GUI to see the comparison results in that format.
Information on the command line can be found here: http://www.red-gate.com/supportcenter/L ... %20Compare
I hope this helps, / comments
Hi leedavies,
If it's always the same tables or a few different common table selections have you tried creating different projects for each? You could then just run these projects as needed. Anot...
Hi russellfoggy,
This isn't something that I have heard of before. If you run an Add-Hoc backup rather than a scheduled task does it complete or are there complications? Are there any error messages in the SQL Server log, the SQL Server Agent log or the Application/System log etc?
Thanks, / comments
Hi russellfoggy,
This isn't something that I have heard of before. If you run an Add-Hoc backup rather than a scheduled task does it complete or are there complications? Are there any error messa...
Hi smilee282000,
If I have grasped this right, you should be able to set Column 1 as your comparison key. Rows of data with the same value in this column will then be compared. You can select your comparison column in the Tables & Views tab when setting up your project.
I hope this helps, / comments
Hi smilee282000,
If I have grasped this right, you should be able to set Column 1 as your comparison key. Rows of data with the same value in this column will then be compared. You can select you...
Hi,
NTVDM is a service which is used to run 16bit programs which to my knowledge we don't touch/use. I am guessing this is a 32 bit Windows 2008 server? Does the SQL Compare 8 GUI work ok?
If you run just SQLCompare /? does the message come up?
Have you tried a reinstall of SQL Compare?
Thanks, / comments
Hi,
NTVDM is a service which is used to run 16bit programs which to my knowledge we don't touch/use. I am guessing this is a 32 bit Windows 2008 server? Does the SQL Compare 8 GUI work ok?
If you...
Hi
In the SQL Response GUI on the Toolbar at the top should be a "From the Last:" drop down box. If you change that to display no filter or a longer period do the Alerts appear?
Thanks, / comments
Hi
In the SQL Response GUI on the Toolbar at the top should be a "From the Last:" drop down box. If you change that to display no filter or a longer period do the Alerts appear?
Thanks,
Hi Lee,
What do you mean by clean up the activity history? If you look in Tools>Options in the GUI there is a setting at the bottom called SQL Server backup history. Setting this option will also delete entries from the internal cache which the Activity History uses. This will keep it shorter.
I hope this helps. / comments
Hi Lee,
What do you mean by clean up the activity history? If you look in Tools>Options in the GUI there is a setting at the bottom called SQL Server backup history. Setting this option will also...
Hi KlausE,
The SQL Data Generator command line is basically just there to enable it to be run from a batch file etc.
All the project specific options can only be set in the SQL Data Generator GUI, these are stored in the project file which can be called from the command line.
It's easier to directly call the project file from the command line rather than calling an argfile which calls the project file.
I hope this helps. / comments
Hi KlausE,
The SQL Data Generator command line is basically just there to enable it to be run from a batch file etc.
All the project specific options can only be set in the SQL Data Generator GUI, ...
Hi EdBorden,
Thank you for your feedback, this will be considered for a future release.
I imagine that with the ability to clear an instance of an alert the comment functionality would then also be available to that level.
Thanks again. / comments
Hi EdBorden,
Thank you for your feedback, this will be considered for a future release.
I imagine that with the ability to clear an instance of an alert the comment functionality would then also be...
Hi vidarm,
What is the Log On account for the SQL Backup Agent Service?
You can check this by opening Windows Services on the SQL Server machine, scrolling down to SQL Backup Agent and viewing Properties>Log On.
Is this a domain account with access to the network share?
If not could you please stop the Service, change the Log On account to a domain account with access, start the service and retry the Test?
Thanks / comments
Hi vidarm,
What is the Log On account for the SQL Backup Agent Service?
You can check this by opening Windows Services on the SQL Server machine, scrolling down to SQL Backup Agent and viewing Prop...