Comments
Sort by recent activity
Hi iLyaL,
For the first part of your
question, the scripts are listed and ordered in the ‘sqlproj’ file that's at
the root of the project.
For the second part, I was
going to recommend using the patch script approach instead of the package
script to improve performance.
https://documentation.red-gate.com/rr1/key-concepts/deployment-scripts I hope this helps. Kind regards, / comments
Hi iLyaL,
For the first part of your
question, the scripts are listed and ordered in the ‘sqlproj’ file that's at
the root of the project.
For the second part, I was
going to recommend using the ...
Hi PPutzback,
Unfortunately, we do not have a way of adding objects to directly to
Source Control through the product. This request has come up before, and
has been submitted as a feature request on the Redgate UserVoice portal
for SQL Source Control.
Can you please comment and/or vote on this existing feature request on our SQL Source Control User Voice Forum?
https://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/1063813-integrate-source-control-explorer
The User Voice forum is the place to submit feature requests, the
more votes and comments a topic receives will increase the chances of it
being included in a future version of the product. The Product Managers
and Development Team actively monitor the User Voice forums. At this
time the topic has 4 votes and one comment.
Kind regards,
/ comments
Hi PPutzback,
Unfortunately, we do not have a way of adding objects to directly to
Source Control through the product. This request has come up before, and
has been submitted as a feat...
Hi IgorS, Sorry for the confusion. I am glad that the solution worked. And yes, that is very fortunate it was not on your production server.I know how much it takes to make any changes to a SOX controlled server.
Please let us know if you have any other questions. Thanks,
/ comments
Hi IgorS,Sorry for the confusion. I am glad that the solution worked. And yes, that is very fortunate it was not on your production server.I know how much it takes to make any changes to a SOX cont...
Hello IgorS,
Thanks for getting in touch. You'll need to add the the user to the BrowsingUserList registry value as described in the following documentation: https://documentation.red-gate.com/sbu10/troubleshooting/cannot-access-resource-when-browsing-sql-servers-with-windows-authentication I hope this helps. Best regards,
/ comments
Hello IgorS,
Thanks for getting in touch.You'll need to add the the user to the BrowsingUserList registry value as described in the following documentation:https://documentation.red-gate.com/sbu10/...
Hi Etienne, Yes. There is a way to remove the brackets from all data types. It is Options -> Format -> Styles -> Actions -> Add/remove square brackets = YES, Remove unnecessary brackets = YES However this will also remove any other brackets a long with it. Unfortunately,
we do not currently have an option for just removing the brackets around data types. This would be considered a feature request to add in a later release of SQL Prompt. You can post a new feature request on our UserVoice forum here:
https://redgate.uservoice.com/forums/94413-sql-prompt Our product manager uses that as an important resource when deciding new features. Best regards, / comments
Hi Etienne,Yes. There is a way to remove the brackets from all data types. It is Options -> Format -> Styles -> Actions -> Add/remove square brackets = YES, Remove unnecessary brackets = YESHowever...
Hi mbass,
Our developers have confirmed that converting the time to UTC is the intended behavior at the moment. I'm sorry to say that there aren't any plans currently to add a feature to disable this, but they have asked if you can please put a feature request for it on our Uservoice forum Here
Our product managers use that forum as an important resource when considering new features and it allows other users to vote on the feature as well, to help add priority. They'll then post any updates to the request there. Kind regards, / comments
Hi mbass,
Our developers have confirmed that converting the time to UTC is the intended behavior at the moment. I'm sorry to say that there aren't any plans currently to add a feature to disable th...
Hi mbass, Are you referring to the Encapsulate as new stored procedure function? Best regards, / comments
Hi mbass,Are you referring to the Encapsulate as new stored procedure function?Best regards,
Hi, I believe this error was caused by the built in IntelliSense that comes with SSMS. I was able to recreate this issue in a Stored Proc without SQL Prompt installed. Please see below: [image] I hope this helps. Please let me know if you have any questions on this. Thanks, / comments
Hi,I believe this error was caused by the built in IntelliSense that comes with SSMS. I was able to recreate this issue in a Stored Proc without SQL Prompt installed. Please see below:I hope this h...
Hello Ikka, Yes, the issue of Datetime formatting was addressed in version 12.3.0.4373. In the release notes it lists:
SDC-2485: DateTime data is now formatted consistently in the differences grid.
Here is a link to the Release Notes (bottom of the page).
If your SQL Data Compare license for version 12.2 is still supported, than you should be able to upgrade to version 12.3. Please let me know if you have any other questions on this. Thanks / comments
Hello Ikka,Yes, the issue of Datetime formatting was addressed in version 12.3.0.4373.In the release notes it lists:
SDC-2485: DateTime data is now formatted consistently in the differences grid.
H...
Hi Doug, The sql backup jobs are ran as the account used for the SQL Backup Agent service. You can change the account used as well as the authentication mode for this service. To change the account used for this service:
From the Windows Control Panel, select Administrative
Tools > Services, or run services.msc.
Select the SQL Backup Agent service for the SQL Server
instance: SQL Backup Agent - <instance name>. Note: The SQL Backup Agent service for the local instance is
called just SQL Backup Agent.
Right-click the service and select Properties.
On the Log On tab, specify the account
you want the service to log on as. The account must have the permissions
listed above.
Click OK to close.
Right-click the service and select Restart to
restart the service and apply your changes.
note: You will need to restart the SQL Backup Agent service for the change to take effect. The rest of the documentation on SQL Backup permissions can be found here I hope this helps / comments
Hi Doug,The sql backup jobs are ran as the account used for the SQL Backup Agent service.You can change the account used as well as the authentication mode for this service.To change the account us...