Comments
Sort by recent activity
Sorry you are experiencing this.
This is a known issue under the internal reference number of SC-5894.
Unfortunately I am unable to provide a timeline for when this might be fixed. / comments
Sorry you are experiencing this.
This is a known issue under the internal reference number of SC-5894.
Unfortunately I am unable to provide a timeline for when this might be fixed.
This option is not in available in the UI but you should be able to modify it in a config file:
c:\Users\<username>\AppData\Local\Red Gate\SQL Prompt 6\RedGate_SqlPrompt_Format_Layout_LayoutOptions.xml
Change the following entry to false:
<IndentBeginToken>False</IndentBeginToken> / comments
This option is not in available in the UI but you should be able to modify it in a config file:
c:\Users\<username>\AppData\Local\Red Gate\SQL Prompt 6\RedGate_SqlPrompt_Format_Layout_LayoutOptions...
Unfortunately there is not currently a method to insert a snippet from the snippet manager.
If you wish you can request this feature here. http://redgate.uservoice.com/forums/944 ... uggestions
These forums are actively monitored by our development team and allow our users to request features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release.
There is a similar existing feature request you may want to vote for. http://redgate.uservoice.com/forums/944 ... ight-click / comments
Unfortunately there is not currently a method to insert a snippet from the snippet manager.
If you wish you can request this feature here.http://redgate.uservoice.com/forums/944 ... uggestions
Thes...
Issues with licenses not taking are usually permissions related.
The tool requires that the logon account of the SQL Backup agent service has access to the licenses folder as well as the registry.
The Red Gate licenses folder %PROGRAMDATA%\Red Gate\Licenses (for Windows Server 2008, Windows Server 2008 R2, Windows Vista and Windows 7) or %ALLUSERSPROFILE%\Application Data\Red Gate\Licenses (for Windows Server 2003 and Windows XP).
The Red Gate licensing registry folder HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\Licensing\SQL Backup or HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Red Gate\Licensing\SQL Backup (for 64-bit machines).
Here is a detailed document on the permissions required. http://documentation.red-gate.com/displ ... ermissions
You can try running the ProductActivation.exe directly on the server.
It is located in the directory where the SQL Backup UI is installed.
C:\Program Files (x86)\Red Gate\SQL Backup 7
When you run the executable make sure you right click and run as administrator.
Check that a .lic file is created in the licenses folder
The Red Gate licenses folder %PROGRAMDATA%\Red Gate\Licenses (for Windows Server 2008, Windows Server 2008 R2, Windows Vista and Windows 7) or %ALLUSERSPROFILE%\Application Data\Red Gate\Licenses (for Windows Server 2003 and Windows XP). / comments
Issues with licenses not taking are usually permissions related.
The tool requires that the logon account of the SQL Backup agent service has access to the licenses folder as well as the registry.
...
I think the command you want to use is
sqlcompare /s1:<servername>\<instancename> /db1:<databasename> /s2:<servername>\<instancename> /db2:<databasename> /sync
Here is a knowledge base article on "Simple examples using the command line" http://documentation.red-gate.com/displ ... mmand+line / comments
I think the command you want to use is
sqlcompare /s1:<servername>\<instancename> /db1:<databasename> /s2:<servername>\<instancename> /db2:<databasename> /sync
Here is a knowledge base article on "...
1) How can I retrieve the latest version of a deleted stored procedure?
You would need to go through the history and find the revision where the table was dropped. This would show the latest version of the stored procedure prior to the drop.
2) Is there are any filter in the window "History" ? Example: i would like to filter all revisions related to this specific stored procedure.
You can right click on a specific object in Object explorer and select show history this will bring up all the revisions that are associated with that object.
Unfortunately this will not work for you because the object was deleted.
If you wish you can request a feature for this particular case in our uservoice forums. http://redgate.uservoice.com/forums/390 ... ce-control
These forums are actively monitored by our development team and allow our users to request features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release. / comments
1) How can I retrieve the latest version of a deleted stored procedure?
You would need to go through the history and find the revision where the table was dropped. This would show the latest versio...
SQL Backup Pro can be installed on SQL Server instances included in AlwaysOn Availability Groups (introduced in SQL Server 2012), but does not support the features of Availability Groups. SQL Backup Pro must be installed on each SQL Server instance separately; you cannot use the cluster installation. In the event of a failover, any scheduled jobs from the failed server must be created manually on the new primary server.
See Technical notes on the requirements page. http://documentation.red-gate.com/displ ... quirements / comments
SQL Backup Pro can be installed on SQL Server instances included in AlwaysOn Availability Groups (introduced in SQL Server 2012), but does not support the features of Availability Groups. SQL Backu...
You can direct feature requests to our uservoice forums. http://redgate.uservoice.com/forums/147 ... uggestions
These forums are actively monitored by our development team and allow our users to request features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release. / comments
You can direct feature requests to our uservoice forums.http://redgate.uservoice.com/forums/147 ... uggestions
These forums are actively monitored by our development team and allow our users to req...
You can direct feature requests to our uservoice forums. http://redgate.uservoice.com/forums/141 ... uggestions
These forums are actively monitored by our development team and allow our users to request features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release. / comments
You can direct feature requests to our uservoice forums.http://redgate.uservoice.com/forums/141 ... uggestions
These forums are actively monitored by our development team and allow our users to req...
This would be considered a feature request.
You can direct feature requests to our uservoice forums. http://redgate.uservoice.com/forums/944 ... uggestions
These forums are actively monitored by our development team and allow our users to request features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release. / comments
This would be considered a feature request.
You can direct feature requests to our uservoice forums.http://redgate.uservoice.com/forums/944 ... uggestions
These forums are actively monitored by our...