Activity overview
Latest activity by SandraV
I got that same access denied when I tried to locate the log files from the SQL Prompt menu. No idea why. I ended up putting in a support ticket and then tried the workarounds, none of which helped. So, I took the downgrade option which meant I lost a lot of my recent tab history but it's opening my tabs when I restart SSMS. Not the best outcome but I'm OK with it. I've saved anything critical to my scripts folder independent of the tool. I'm more interested in the faster tab history and the ability to open tabs on startup. / comments
I got that same access denied when I tried to locate the log files from the SQL Prompt menu. No idea why.I ended up putting in a support ticket and then tried the workarounds, none of which helped...
I have problem #1 as well. However, I always login to SSMS with a shortcut I setup that executes runas.exe in the target to prompt for a password to alternate credentials and don't see #2. Unfortunately, what has recently happened is that my open tabs are no longer restored at startup. I tried to toggle this on and off with shutdowns in-between. I thought this maybe had to do with my opening SSMS under different credentials recently, as this sometimes makes SQL Prompt behave oddly but maybe it's this upgrade. / comments
I have problem #1 as well. However, I always login to SSMS with a shortcut I setup that executes runas.exe in the target to prompt for a password to alternate credentials and don't see #2. Unfort...
A found a solution, though not a great solution.
I backed up/restored the source DB to create a copy of the source, ran sp_dropextendedproperty for SQLSourceControl Database Revision, SQLSourceControl Scripts Location, and SQLSourceControl Scripts Location on the copy, and was able to get SQL Compare to work against the copy and my production DB. / comments
A found a solution, though not a great solution.
I backed up/restored the source DB to create a copy of the source, ran sp_dropextendedproperty for SQLSourceControl Database Revision, SQLSourceCont...
SQL Compare aborts - Could not find a part of the path
SQL Compare is aborting during the check for source drift step with the error Could not find a part of the path 'C:\Users\username\AppData\Local\Temp\srk2fozc.m0j', where username is my username an...