Activity overview
Latest activity by markv
That did indeed work though I made sure to keep the Case Sensitivity of the filename within SVN. Now, I just need to see whether the differences list are because I have changed things since the database was committed or whether the latest commit using SQL Compare is out of date. / comments
That did indeed work though I made sure to keep the Case Sensitivity of the filename within SVN. Now, I just need to see whether the differences list are because I have changed things since the da...
I had half through about doing this, though the Source Control generates more folders than the scripts did, so wasn't sure if that mattered? (Will be giving it a go shortly and let you know). / comments
I had half through about doing this, though the Source Control generates more folders than the scripts did, so wasn't sure if that mattered? (Will be giving it a go shortly and let you know).
In SSMS it will not drop a table unless you have the "Allow DROP" option ticked with in the preferences. Also, the only time it will drop a table and recreate is if there is a need to.
Adding a new column to the end of the database table does not but if you drag it around to place it in a specific column order this will. Also, other options you specify as part of the column may cause a drop.
The best way to see this is by either keeping the Allow Drop option disabled or generating a script of the changes before applying them. If the script creates a temporary table then inserts data from the existing table, it is going to be dropping and recreating. / comments
In SSMS it will not drop a table unless you have the "Allow DROP" option ticked with in the preferences. Also, the only time it will drop a table and recreate is if there is a need to.
Adding a new...
BUG: Recreated Login not updated correctly into SVN
If you create a login with user mapping, then delete both and recreate but use a different login name to the user, this is correctly picked up in the compare.
However, it is not actually committed ...
Updating Scripts folder to SVN
Currently, we have always used SQL Compare to create a Scripts folder then SVN Commit'd that into the repository. The Source Control appears to use the same structures (albeit with more directories...
I have finally given up on SQL Prompt 5 too... it was just cause too many issues with locking up the SSMS at random times. Today's was that I was browsing through my tables and went to right click... then nothing else worked and SSMS even disappear from the taskbar though it was actually still running when you alt-tab'd! / comments
I have finally given up on SQL Prompt 5 too... it was just cause too many issues with locking up the SSMS at random times. Today's was that I was browsing through my tables and went to right click...
I may not close my SSMS window for a long time then [image] / comments
I may not close my SSMS window for a long time then
Interesting... I didn't fix the problem but I found that I could bypass it by cancelling the first dialog that SSMS normally prompts you with and THEN connecting. / comments
Interesting... I didn't fix the problem but I found that I could bypass it by cancelling the first dialog that SSMS normally prompts you with and THEN connecting.
Click CANCEL on the initial connection dialogue, and then make your connects via Object Explorer etc.
You can modify SSMS to open an empty environment so you aren't constantly having to click CANCEL but that's the way I figured to get around this... / comments
Click CANCEL on the initial connection dialogue, and then make your connects via Object Explorer etc.
You can modify SSMS to open an empty environment so you aren't constantly having to click CANCE...
I have found the same hang with SSMS 2008 R2. What I found cured this was to cancel the initial connection dialog and then try to connect. All appears to be OK from then on.
You can make this the default in SSMS 2008 by going to Tools -> Options and set it to open an empty environment at startup. / comments
I have found the same hang with SSMS 2008 R2. What I found cured this was to cancel the initial connection dialog and then try to connect. All appears to be OK from then on.
You can make this the...