How can we help you today? How can we help you today?
grantph
Activity overview Badges (0) Posts (2) Comments (3)

Activity overview

Latest activity by grantph

Thanks Chris. If I use "contact support" rather than the forums, will this speed up the process? / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SQL Compare Error when users exceed 32768
Thanks Chris. If I use "contact support" rather than the forums, will this speed up the process?
0 votes
Thanks. A quick fix would be appreciated as we currently can't migrate to our production database using SQL Compare. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SQL Compare Error when users exceed 32768
Thanks. A quick fix would be appreciated as we currently can't migrate to our production database using SQL Compare.
0 votes
Logfile extract follows: 08:09:23.135|Info |SQL Compare Engine |7 |Populate Event Notifications start. 08:09:23.135|Info |SQL Compare Engine |7 |Populate DDL Triggers start. 08:09:23.135|Info |SQL Compare Engine |7 |Populate XML Schema Collections start. 08:09:23.135|Info |SQL Compare Engine |7 |Populate Certs start. 08:09:23.151|Info |SQL Compare Engine |7 |Populate SKeys start. 08:09:23.151|Info |SQL Compare Engine |7 |Populate AKeys start. 08:09:23.151|Info |SQL Compare Engine |7 |Populate Extended Properties start. 08:09:23.182|Info |SQL Compare Engine |7 |Populate Permissions start. 08:09:23.260|Error |SQL Compare UI |1 |Exception in progress dialog System.Data.SqlClient.SqlException: Arithmetic overflow error for data type smallint, value = 32768. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.HasMoreRows() at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) at System.Data.SqlClient.SqlDataReader.Read() at s.Read() at n.H() at n.F() at n.a(m ) at RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties connectionProperties, Options options) at ap.DoRegisterDatabaseForCompare(Database database, LiveDatabaseSource dataSource) at ap.DoRegisterDatabaseForCompare(Database database, DataSource dataSource) at ap.DoRegisterDatabase2ForCompare() at RedGate.Shared.Utils.ProgressTasks.ProgressTask.a() at RedGate.Shared.Controls.ProgressDialogEx.e() / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SQL Compare Error when users exceed 32768
Logfile extract follows: 08:09:23.135|Info |SQL Compare Engine |7 |Populate Event Notifications start. 08:09:23.135|Info |SQL Compare Engine |7 |Populate DDL Triggers start. 08:09:23.135|In...
0 votes
SQL Compare Error when users exceed 32768
  1. Community
  2. SQL Compare Previous Versions
I'm receiving an "Arithmetic overflow error for data type smallint, value = 32768" during the Registering Databases - Reading Permissions process on a large database. Our database recently exceeded...
2 followers 8 comments 0 votes
Full-text indexing bug when used with image columns
  1. Community
  2. SQL Compare Previous Versions
Hello Support, I have database table that uses full text indexes on image columns. When using image columns, SQL Server requires a second column indicating the extension. Example: Data image, Da...
1 follower 1 comment 0 votes
Total activity
6
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1