SQL Source Control can't check in SQL 2008 in Version 8.0.2.21112. I get a long error of:
Incorrect syntax near the keyword 'IS'.
at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()
at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at Microsoft.Data.SqlClient.SqlCommand.ExecuteScalar()
at RedGate.SQLSourceControl.Engine.Utils.SqlQueries.GetActiveUser(IDbConnection connection)
at RedGate.SQLSourceControl.Engine.CompareEngineImpl.DatabasePropertiesRetriever.GetDatabaseProperties(String connectionString, IEngineOptions options)
at RedGate.SQLSourceControl.Engine.CompareEngineImpl.DatabaseConnection.<>c__DisplayClass7_0.<.ctor>b__0()
at System.Lazy`1.CreateValue()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Lazy`1.get_Value()
at RedGate.SQLSourceControl.Engine.CompareEngineImpl.DatabaseConnection.get_IsMasterAvailable()
at RedGate.SQLSourceControl.CommonUI.DatabaseViewController.TryGetActiveUser(String& activeUser)
at RedGate.SQLSourceControl.UI.Services.DatabaseModelBuilder.BuildDatabaseModel()
at RedGate.SQLSourceControl.UI.WPF.ViewModels.ObjectLocking.ObjectLockingInstalledViewModel.<GetLockedObjects>d__45.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at RedGate.SQLSourceControl.UI.WPF.Utils.ObservableTask`1.<WatchTaskAsync>d__1.MoveNext()
SQL Source Control can't check in SQL 2008 in Version 8.0.2.21112. I get a long error of:
Incorrect syntax near the keyword 'IS'.
at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()
at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at Microsoft.Data.SqlClient.SqlCommand.ExecuteScalar()
at RedGate.SQLSourceControl.Engine.Utils.SqlQueries.GetActiveUser(IDbConnection connection)
at RedGate.SQLSourceControl.Engine.CompareEngineImpl.DatabasePropertiesRetriever.GetDatabaseProperties(String connectionString, IEngineOptions options)
at RedGate.SQLSourceControl.Engine.CompareEngineImpl.DatabaseConnection.<>c__DisplayClass7_0.<.ctor>b__0()
at System.Lazy`1.CreateValue()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Lazy`1.get_Value()
at RedGate.SQLSourceControl.Engine.CompareEngineImpl.DatabaseConnection.get_IsMasterAvailable()
at RedGate.SQLSourceControl.CommonUI.DatabaseViewController.TryGetActiveUser(String& activeUser)
at RedGate.SQLSourceControl.UI.Services.DatabaseModelBuilder.BuildDatabaseModel()
at RedGate.SQLSourceControl.UI.WPF.ViewModels.ObjectLocking.ObjectLockingInstalledViewModel.<GetLockedObjects>d__45.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at RedGate.SQLSourceControl.UI.WPF.Utils.ObservableTask`1.<WatchTaskAsync>d__1.MoveNext()