Activity overview
Latest activity by Christian Perez
Hi Dan, Thanks for reaching out to Redgate Support and sorry to hear you are having some trouble with your SQL Prompt install after updating to the latest version. Version 11 of Prompt was designed to support Azure Synapse Dedicated Pools, so likely something is not playing nominally with that interaction in your environment post update. In this case, we are troubleshooting this locally, so you may benefit from uninstalling and reinstalling the previous version of Prompt so that you can continue working in the meantime. You can find the link to our installation media HERE: https://download.red-gate.com/checkforupdates/SQLPrompt/ Can you try uninstalling and reverting one version and then let us know if that fixes you temporarily? Best, Christian Perez / comments
Official comment
Hi Dan, Thanks for reaching out to Redgate Support and sorry to hear you are having some trouble with your SQL Prompt install after updating to the latest version. Version 11 of Prompt was designed...
Hi Magnus, As Jane L. Lovett kindly mentioned, this is likely a permissions issue in your environment. You can find a full list of the required permissions for SQL Prompt on the following webpage: https://documentation.red-gate.com/sp/getting-started/requirements/sql-server-permissions However the key permissions are: User granted SELECT & VIEW DEFINITION on a database User granted VIEW ANY DEFINITION User is a member of the sysadmin role User is granted VIEW SERVER STATE Can you confirm you have the above permissions set and let us know if the behavior changes? / comments
Official comment
Hi Magnus, As Jane L. Lovett kindly mentioned, this is likely a permissions issue in your environment. You can find a full list of the required permissions for SQL Prompt on the following webpage: ...
Hi Terry, Thanks for reaching out to Redgate Support, sorry to hear you are having some trouble with your SQL Prompt installation. In this case, since your shared snippets appear to be missing you may need to re-login to RedgatePlatform. If you click on SQL Prompt > in SSMS, do you see an option for “Login to Redgate Platform”? If so go ahead and click on that and login and then see if your shared snippets return. / comments
Official comment
Hi Terry,Thanks for reaching out to Redgate Support, sorry to hear you are having some trouble with your SQL Prompt installation. In this case, since your shared snippets appear to be missing you m...
Hi James, Hope this finds you well, thanks for reaching out to Redgate Support regarding your issue with Compare. In this case, is the de-select all options not sufficient for your use-case? As for refreshing the comparison, it already behaves in the manner you describe, if I select only a few objects from below comparison and then hit refresh, the same objects are selected after the comparison is completed. [image] If the above is not what you are referring to, could I kindly request a screenshot of the behavior in question? / comments
Official comment
Hi James, Hope this finds you well, thanks for reaching out to Redgate Support regarding your issue with Compare. In this case, is the de-select all options not sufficient for your use-case? As for...
HI James, Thanks for reaching out to Redgate Support regarding this SQL Source Control behavior you are seeing. Reviewing through that error, I think you may find use from the following troubleshooting article on partition schemes not being located. There is also some information about partition functions in this article, could you try the steps and let me know if the behavior changes? https://productsupport.red-gate.com/hc/en-us/articles/360007874773-The-partition-scheme-xxx-on-table-yyy-was-not-found / comments
HI James,Thanks for reaching out to Redgate Support regarding this SQL Source Control behavior you are seeing. Reviewing through that error, I think you may find use from the following troubleshoot...
Hi James, Appreciate all the feedback here. The whitespace being inserted is likely something on Compares script generation engine, of which I do not see a manner to manipulate the amount of whitespace. Maybe we can have better luck if we look at any changes performed recently to the application, was this behavior something you started seeing after performing an update to the product? / comments
Hi James, Appreciate all the feedback here. The whitespace being inserted is likely something on Compares script generation engine, of which I do not see a manner to manipulate the amount of whites...
Hi Roman, Thanks for reaching out to Redgate Support, as we have already had the pleasure of chatting I am going to put the answer from our investigation here for other users as well. In this case, the issue is due to the switch /Exclude:table:\[dbo]\.\[ENTDropDownListItem] from the command line sqldatacompare.exe /scripts1:"C:\Users\XXXXXXXXX\source\repos\EMS Phase 2\DB\Inv" /database2:"Inv" /server2:"localhost" /Exclude:table:\[dbo]\.\[ENTDropDownListItem] /ScriptFile:"C:\temp\SyncScript_exclude_ENTDropDownList.sql" being passed Being passed in the options Parameter field of the Azure Release task. You cannot pass a command line switch in this field, so you either need to create a new filter file and pass it in the Filter File field, or continue using the command line option where you can pass the /Exclude:table:\[dbo]\.\[ENTDropDownListItem] Switch. / comments
Official comment
Hi Roman,Thanks for reaching out to Redgate Support, as we have already had the pleasure of chatting I am going to put the answer from our investigation here for other users as well. In this case, ...
Hi mbarbhaya , Thanks for reaching out to Redgate Support. Based off your initial description it seems as if you would benefit from our SQL Compare application where you can provide SQL Compare with 2 databases (Which can both exist on different servers) and then SQL Compare will perform a comparison of the two databases and can deploy the changes from 1 database to another to make them identical or to deploy a few tables only. Does the above sound like what you are aiming to perform here? / comments
Official comment
Hi mbarbhaya , Thanks for reaching out to Redgate Support. Based off your initial description it seems as if you would benefit from our SQL Compare application where you can provide SQL Compare wit...
Hi James, Given these behavioral changes you are seeing seem to be caused by the amount of whitespace in your script, could I suggest that you try going into your SQL Compare Options and check off the comparison option for “Ignore whitespace” and then try this test again and let us know if any change in behavior occurs? Cheers, Christian Perez Product Support Engineer / comments
Hi James, Given these behavioral changes you are seeing seem to be caused by the amount of whitespace in your script, could I suggest that you try going into your SQL Compare Options and check off ...
Hi ahraitch , Thanks for reaching out to Redgate Support and sorry for the delay in my initial response. In this case what I would like you to do is double check we are running our queries from the correct interface window, so if you were to right-click on the dbo.clanPeople table in the Object Explorer and select the option “Select Top 1000 rows” and then reattempt to run Alter TABLE dbo.ClanPEOPLE ADD peopleSpouseID Nchar(10); Is Alter still not recognized? Cheers, Christian Perez Product Support Engineer / comments
Official comment
Hi ahraitch ,Thanks for reaching out to Redgate Support and sorry for the delay in my initial response. In this case what I would like you to do is double check we are running our queries from the ...