Activity overview
Latest activity by rbennet8
table differences which are not different
I used Visual Studio 2012. I imported a new dbproj from my database which was on SQL Server 2012.
I then published the new VS 2012 dbproj to a new database on SQL 2012.
When I run SQL compare to ve...
comments confuse reformat
consider this snippet.@back_up_path varchar(500), -- path for backup directory@log_path varchar(500), -- path for log directory@JobID BINARY(16),
If you choose comma first, reformat changes it to
,...
VS2010 schema compare?
Does visual Studio 2010 use sql compare when it performs schema compare? I recently installed the 10.2 version of Sql Compare and now my schema compare in VS2010 seems to have changed.
SQL 2012 SSMS crashes
I just installed V3.0.12. It seems to work if I use SQL 2008 SSMS except it send a msg to Red Gate at start up.The type initializer for 'RedGate.SharedSSMS.Util.ReflectionUtils' threw an exception....
Actually it is just happening on my PC, but currently I am the one in our group testing Source Control 3. I am running SSMS 2008 R2 version 10.50.2772. It is the password for SQL Server Authentication that is being forgotten.
However, today I discovered another piece of the puzzle. When I just start SSMS and connect to the server and work with a stored proc, then exit, it remembers the password. But if I commit the changes, then exit, it forgets the password. Also, if I edit the stored proc and use one of the sql Prompt 5 options like uppercase keywords, the next time I try to connect, the password field is empty. / comments
Actually it is just happening on my PC, but currently I am the one in our group testing Source Control 3. I am running SSMS 2008 R2 version 10.50.2772. It is the password for SQL Server Authenticat...
Temp table causes issue with qualify object names
If the stored proc has a #temp table defined, then the qualify object names underlines all references to the #temp and says it cannot complete the request.
SQL password
After I installed source control 3, I have noticed that when I load SSMS using SQL authentication, it does not remember my password even when I check the remeber password option. If I log in to a d...
encoding issues
I have two screen shots that I can send if you will explain how to attach.
The first shows the text as it appears in a stored procedure script created in SSMS. The second shows the comparison of tw...
Sql 2012 SSMS
Will there be a release soon of SQL Compare 10 that allows you to use SSMS 2012 as the script editor? I have the current version and SQL 2012 is not an option.
Reseed tables not selected for Synchronization
I unselected the reseed option for the project. I compared two databases with all tables selected. I selected one table which did not have an identity column for Synchronization. 7 unrelated tables...