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

Comments

Sort by recent activity
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
  1. Community
  2. SQL Prompt Previous Versions
  3. Unable to refresh or cache database
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
I already have Ignore Whitespace enabled. After enabling Ignore Extended Properties, I get the same response. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. False positives with FILESTREAM??
I already have Ignore Whitespace enabled. After enabling Ignore Extended Properties, I get the same response.
0 votes
Total activity
5
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2