How can we help you today? How can we help you today?
bauerga

Activity overview

Latest activity by bauerga

False positives with FILESTREAM??
I have a table that appears in the list view as having differences, but there are no differences in the side-by-side view. Just for grins, I have executed the synchronization script but still get t...
2 followers 3 comments 0 votes
When I open a query on a SQL 2008 database, I receive the following error: Unable to refresh or cache database [SQD-102\QSRV1].[OWCD_CESYSTEM] due to the following error: The user does not have permission to perform this action.. RedGate.SqlPrompt.Engine.Cache.DatabaseRefreshException: Unable to refresh or cache database [SQD-102\QSRV1].[OWCD_CESYSTEM] due to the following error: The user does not have permission to perform this action.. ---> System.Data.SqlClient.SqlException: The user does not have permission to perform this action. 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.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at v.a(String ) at v.ExecuteSqlSetting() at o.aa() at o.a(n ) at RedGate.SQLCompare.Engine.Database.RegisterForSqlPrompt(ConnectionProperties connectionProperties, Options options, Boolean includeSystemObjects, Boolean includeDependencies) at cy.b(IAuthenticationTokenProvider ) --- End of inner exception stack trace --- at cy.b(IAuthenticationTokenProvider ) at cy.a(IAuthenticationTokenProvider ) at cy.GetMetaData(IAuthenticationTokenProvider provider) at M.b(G , IAuthenticationTokenProvider , Boolean , EventHandler`1 , EventHandler`1 , EventHandler`1 , EventHandler`1 ) I am dbo on this database, and SQL Prompt seems to function after clicking through on the error. What are the permissions this message refers to? / comments
When I open a query on a SQL 2008 database, I receive the following error: Unable to refresh or cache database [SQD-102\QSRV1].[OWCD_CESYSTEM] due to the following error: The user does not have per...
0 votes