Comments
Sort by recent activity
Hi @helibirdy, You can reduce the privilege. The below outlines what is required permissions wise to access that information: [image] Link to the documentation / comments
Hi @helibirdy,You can reduce the privilege. The below outlines what is required permissions wise to access that information:Link to the documentation
Hi @TheHartz, Apologies for the delay. There's a possibility you can make use of the "Use Existing Data Source" when populating data. Essentially, it works by selecting the data from another table to populate the table you have selected, for the purpose of not overwriting the data you want to keep. This means you have to create a second table with the same data that's in the first table. The reason you'd have to do this, is because if you stay with the normal option of generating data, it will delete/truncate the already existing data. The way I have suggested allows you to populate the columns that would otherwise be overwritten to NULL, with the data from the duplicated table. In my instance I have 2 separate tables, lets call them Table1 and Table2. I have duplicated the data from Table1 into Table2, and on the generator, I have specified that I wish to pull the data from Table2. This then allows me to specify in column 3, that I wish to insert the data from the Table data. The other 2 columns can then have their data generated as per normal. [image] [image] [image] [image] active_flg is the column I wish to remain using the data that's already in there. house_id and house_desc is something I'll let the generator create. Here is the documentation for this: https://documentation.red-gate.com/sdg/using-existing-sources/mapping-sql-tables-or-views / comments
Hi @TheHartz,Apologies for the delay. There's a possibility you can make use of the "Use Existing Data Source" when populating data. Essentially, it works by selecting the data from another table t...
Hi TheHartz, You can make use the of the "Use Default Values" option. Select the column in question and then choose this option in the drop down. [image] [image] / comments
Hi TheHartz,You can make use the of the "Use Default Values" option. Select the column in question and then choose this option in the drop down.
Spam / comments
Spam
Hi @DaveBrown, Can you check the "URL settings" entry at the bottom of the Configuration > Notification settings is correct? This is what is used by the scheduled reports to download the report. The 404 error usually means the URL on the notification settings page is wrong. / comments
Hi @DaveBrown,Can you check the "URL settings" entry at the bottom of the Configuration > Notification settings is correct? This is what is used by the scheduled reports to download the report. The...
Hi @rsiem, Unfortunately, there is no way to export to an excel or CSV file, but there is a database located in the following directory that you could backup. This could be copied to another machine for example, but reviewing it would still remain in the SQL Prompt GUI. %localappdata%\Red Gate\SQL Prompt 10\SavedTabs.db / comments
Hi @rsiem,Unfortunately, there is no way to export to an excel or CSV file, but there is a database located in the following directory that you could backup. This could be copied to another machine...
Hi @torsten.strauss Thanks for the clarification. I've tested this on an Azure SQL Database and have managed to replicate your initial post. SQL Server Database [image] [image] Azure SQL Database [image] [image] I'll go ahead and get this logged with the development team. I'll let you know as soon as we have any updates.[image] [image] [image] [image] [image] / comments
Hi @torsten.strauss Thanks for the clarification.I've tested this on an Azure SQL Database and have managed to replicate your initial post.SQL Server DatabaseAzure SQL DatabaseI'll go ahead and get...
Hi @torsten.strauss Your issue should now be fixed in the most recent release of SQL Prompt: You can update from the following link: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.10.2.25539.exe / comments
Hi @torsten.strauss Your issue should now be fixed in the most recent release of SQL Prompt:You can update from the following link:https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_...
Hi @torsten.strauss, May I ask which version of SQL Prompt you are currently using? I've done a bit of testing myself on 10.8.4.24201 and I'm not able to replicate exactly what you're encountering. Using the code in the following guide to create a table with a partition, I can see that SQL Prompt is showing everything related to the partition. (https://www.mssqltips.com/sqlservertip/2888/how-to-partition-an-existing-sql-server-table/) Below is the example: [image] You can see it has everything related to the partition included in the hover over create script. Running this script works, so long as the partition scheme has been created/exists first. / comments
Hi @torsten.strauss,May I ask which version of SQL Prompt you are currently using? I've done a bit of testing myself on 10.8.4.24201 and I'm not able to replicate exactly what you're encountering.U...
Hi @mweis, Thank you for providing the updates. Could I suggest a full uninstall of SQL Prompt and re-install, if you haven't tried this already? I've been unable to replicate this on my machine, so let me know if the re-install works. / comments
Hi @mweis,Thank you for providing the updates.Could I suggest a full uninstall of SQL Prompt and re-install, if you haven't tried this already? I've been unable to replicate this on my machine, so ...