Comments
Sort by recent activity
Simple fix. On the right hand side, choose index, Reindex. Worked like a charm. / comments
Simple fix. On the right hand side, choose index, Reindex. Worked like a charm.
Thanks for the quick reply Brian. What's wierd is I'm actually performing a database to database compare and still getting this error. I do have SQL Source Control installed on the destination. And when trying to view history on an object, I'm getting a similar error:
A duplicate definition was found for the index [index name]. Ensure that case sensitivity options are set correctly and all object creation scripts are valid. If the problem persists, contact our support.
Maybe this is a SQL Source Control issue. / comments
Thanks for the quick reply Brian. What's wierd is I'm actually performing a database to database compare and still getting this error. I do have SQL Source Control installed on the destination. ...
I actually resolved the issue. The problem was that we replaced a view with a table of the same name. SQL Source Control (or SQL Compare) appeared to be validating the new table definition before factoring in the view delete and an exception was thrown. Went in and manually removed the view from TFS and everything worked great. / comments
I actually resolved the issue. The problem was that we replaced a view with a table of the same name. SQL Source Control (or SQL Compare) appeared to be validating the new table definition before...
Thanks Eddie. That pretty much sums it up. I really hope that this gets some looks from the dev team. And thanks again for all the time you put into answering my question. / comments
Thanks Eddie. That pretty much sums it up. I really hope that this gets some looks from the dev team. And thanks again for all the time you put into answering my question.
Greetings Eddie, thanks for helping me dig through. I implemented the code change you suggested below, and polling continues. I also tried the below version using standalone="yes" instead of standalone="true", as per some other XML posts that I came across. Do you have any other thoughts. Are any of these setting dependant on OS version, SQL version, or some other attribute? I'd also be happy to give you a call if that would make it easier. <?xml version="1.0" encoding="UTF-16" standalone="yes" ?>
- <!--
-->
- <EngineOptions type="EngineOptions" version="3">
<PollingEnabled>False</PollingEnabled>
</EngineOptions>
/ comments
Greetings Eddie, thanks for helping me dig through. I implemented the code change you suggested below, and polling continues. I also tried the below version using standalone="yes" instead of stan...
Hello Eddie, thanks again for reaching out. Sorry for the confusion above. I was attempting a number of different options to try to get this to work. I applied to code below to C:\Documents and Settings\[my username]\Local Settings\Application Data\Red Gate\SQL Source Control 3\RedGate_SQLSourceControl_Engine_EngineOptions.xml and I still can't seem to disable polling. I'm not sure if it matters, but I do have SQL Server 2008r2, and SQL Server 2012 installed on my local. After making the change below, I attempted to access Source Control in each enviornment through SSMS and it is still "Checking for Changes" on initial click of each db. <?xml version="1.0" encoding="UTF-16" standalone="true"?>
<!---->
<EngineOptions type="EngineOptions" version="2">
<PollingEnabled>False</PollingEnabled>
</EngineOptions>
I even tried deleting and reinstalling SQL Source Control and it didn't help. Any other thoughts? / comments
Hello Eddie, thanks again for reaching out. Sorry for the confusion above. I was attempting a number of different options to try to get this to work. I applied to code below to C:\Documents and ...
Just offering an update: I uninstalled RegGate Source Control again and completely deleted the C:\Users\[me]\AppData\Local\Red Gate\SQL Source Control 3 directory. I then reinstalled based on the most recent developer bundle from the redgate site and updated RedGate_SQLSourceControl_Engine_EngineOptions.xml to look like this. <?xml version="1.0" encoding="UTF-16" standalone="yes"?>
<!---->
<EngineOptions type="EngineOptions" version="3">
<PollingEnabled>False</PollingEnabled>
</EngineOptions>
After I restarted SSMS and relinked a database, I'm still polling. Any other thoughts? / comments
Just offering an update: I uninstalled RegGate Source Control again and completely deleted the C:\Users\[me]\AppData\Local\Red Gate\SQL Source Control 3 directory. I then reinstalled based on the...
Thanks for the quick reply Eddie. I'm still unable to disable the auto check for updates. I updated RedGate_SQLSourceControl_Engine_EngineOptions.xml in
C:\Users\[my username]\AppData\Local\Red Gate\SQL Source Control 3\RedGate_SQLSourceControl_Engine_EngineOptions.xml to reflect the following:
<?xml version="1.0" encoding="utf-16" standalone="yes" ?>
- <!-- SQL Compare 10
SQL Compare
Version:10.1.0.102
-->
- <EngineOptions version="2" type="EngineOptions">
<PollingEnabled>False</PollingEnabled>
</EngineOptions>
Then completely restarted.
I also tried:
<?xml version="1.0" encoding="utf-16" standalone="yes" ?>
- <!-- SQL Compare 10
SQL Compare
Version:10.1.0.102
-->
- <EngineOptions version="2" type="EngineOptions">
<Polling-Enabled>False</Polling-Enabled>
</EngineOptions>
I'm still getting the auto-check for modifications. Is there anything else that I can try? / comments
Thanks for the quick reply Eddie. I'm still unable to disable the auto check for updates. I updated RedGate_SQLSourceControl_Engine_EngineOptions.xml in
C:\Users\[my username]\AppData\Local\Red G...