How can we help you today? How can we help you today?
GaryHampson
Activity overview Badges (0) Posts (5) Comments (7)

Activity overview

Latest activity by GaryHampson

In version 2.1.1.3, this issue is still occurring: RedGate.SQLCompare.Engine.ExtendedPropertyValue / comments
  1. Community
  2. SQL Doc Previous Versions
  3. Extended properties not retrieved correctly in ver 2.1.0.220
In version 2.1.1.3, this issue is still occurring: RedGate.SQLCompare.Engine.ExtendedPropertyValue
0 votes
Anu Deshpande wrote: Thanks for the update. Are you using VPN to connect to the remote database? And also let us know the detailed version of SQL Prompt? You can know the detailed version of SQL Prompt by navigating to SQL Prompt --> About SQL Prompt and version number is displayed on bottom right (just above Close button.) Kindly let us know above details that will help us to investigate further. I am not using VPN to connect. The version of SQL Prompt is 3.9.0.43. / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Unable to refresh or cache database
Anu Deshpande wrote: Thanks for the update. Are you using VPN to connect to the remote database? And also let us know the detailed version of SQL Prompt? You can know the detailed version of SQL ...
0 votes
Anu Deshpande wrote: Thanks for your post Gary. Can you please try to delete the existing cache by navigating to SQL Prompt--> Cache Management and delete all the cache and open and new query window that will recreate the cache and this should resolve your issue. Kindly let us know if that helped. Have deleted all cached databases and am still getting the same error regardless of database (have tried master this time instead of the Cobra database) Unable to refresh or cache database [IBLONPSP33X281\AME].[master] due to the following error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified). RedGate.SqlPrompt.Engine.Cache.DatabaseRefreshException: Unable to refresh or cache database [IBLONPSP33X281\AME].[master] due to the following error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified). ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at RedGate.SqlPrompt.Engine.ConnectionProperties.RetrieveServerDetails() at RedGate.SqlPrompt.Engine.ConnectionProperties.j(ConnectionProperties , IAuthenticationTokenProvider , Boolean ) 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 ) / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Unable to refresh or cache database
Anu Deshpande wrote: Thanks for your post Gary. Can you please try to delete the existing cache by navigating to SQL Prompt--> Cache Management and delete all the cache and open and new query win...
0 votes
Hi Red Gate folks, I am getting the following error message when I try to refresh the cache of a previously accessed database: Unable to refresh or cache database [IBLONPSP33X281\AME].[Cobra] due to the following error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified). RedGate.SqlPrompt.Engine.Cache.DatabaseRefreshException: Unable to refresh or cache database [IBLONPSP33X281\AME].[Cobra] due to the following error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified). ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at RedGate.SqlPrompt.Engine.ConnectionProperties.RetrieveServerDetails() at RedGate.SqlPrompt.Engine.ConnectionProperties.j(ConnectionProperties , IAuthenticationTokenProvider , Boolean ) at cy.b(IAuthenticationTokenProvider ) --- End of inner exception stack trace --- at cy.b(IAuthenticationTokenProvider ) at cy.Refresh(IAuthenticationTokenProvider provider) at ao.DoTask() I am connected to the database in question and can query with no issue. Any ideas? Gary / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Unable to refresh or cache database
Hi Red Gate folks, I am getting the following error message when I try to refresh the cache of a previously accessed database: Unable to refresh or cache database [IBLONPSP33X281\AME].[Cobra] due ...
0 votes
Turn off entries in Application Log
  1. Community
  2. SQL Backup Previous Versions
Is there a way to turn off writing to the Application Event Log upon RESTORE or BACKUP?
2 followers 2 comments 0 votes
Daniel Handley wrote: Hi Gary The problem is probably due to the text in row value being larger than the page size. If you don't have any entries who’s length is greater than 5193 you will still receive the error. Here is a statement to execute on the database to check the text in row value. exec sp_MsForEachTable "SELECT OBJECTPROPERTY(object_id('?'),'TableTextInRowLimit') AS '?'" Once you have found the problem you can use the store procedure sp_tableoption and change the option value 'text in row' to less than 8108. Regards Dan I have run the SP and I have no tables where that property has been set. (all return 0). Any other ideas? Peace, Gary Hampson / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Cannot sort a row of size...
Daniel Handley wrote: Hi Gary The problem is probably due to the text in row value being larger than the page size. If you don't have any entries who’s length is greater than 5193 you will sti...
0 votes
Cannot sort a row of size...
  1. Community
  2. SQL Compare Previous Versions
Hello Brian, I have been getting this error when I run SQL Compare from the command line:Error: Error occurred connecting to database: Cannot sort a row of size 8108, which is greater than the allo...
2 followers 3 comments 0 votes
I too have been experiencing this same issue. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. dtproperties
I too have been experiencing this same issue.
0 votes
That is wonderful!! Thanks again Brian.. You are the best!! / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Argfile and regex assistance
That is wonderful!! Thanks again Brian.. You are the best!!
0 votes
Argfile and regex assistance
  1. Community
  2. SQL Compare Previous Versions
Brian, I've been enjoying using the command line interface of the Compare tool and it has been very helpful thus far, but I am having a little difficulty in the granularity of selecting objects to ...
2 followers 2 comments 0 votes
Total activity
17
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
5