Comments
Sort by recent activity
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...
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...
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.
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
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...
If I recall, I had completely to uninstall SQL Prompt 5 and reinstall it before it would reappear. Though I suspect I had to do that more than once for some reason.
I'm using SQL 2008 R2 SSMS. / comments
If I recall, I had completely to uninstall SQL Prompt 5 and reinstall it before it would reappear. Though I suspect I had to do that more than once for some reason.
I'm using SQL 2008 R2 SSMS.
I tried this and the old menus disappeared but the SQL Prompt 5 menu did not reappear. / comments
I tried this and the old menus disappeared but the SQL Prompt 5 menu did not reappear.