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

Activity overview

Latest activity by damcis

Totally agree. I've been fighting with the two lists displaying at the same time and it was aggravating. I wanted the red error lines, but didn't want the list from intellisense, wanted it from Sql prompt. Thanks for pointing out how to disable the intellisense list!! / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. SQL Prompt versus SSMS 2012 intellisense
Totally agree. I've been fighting with the two lists displaying at the same time and it was aggravating. I wanted the red error lines, but didn't want the list from intellisense, wanted it from S...
0 votes
I'm running latest version of SQL Prompt. I can only tell that by trying to install it again. SSMS 2008 R2 on Window 7 64bit Also, it had been working before, but my pc crashed (had to shut it down using the power button cause it wouldn't shut down normally) and it no longer shows in the menu. The tools menu shows sql compare, data compare, data generator, etc. I have completely reinstalled SSMS 2008 R2 and Sql Toolbelt and it didn't help. System restores don't go back far enough to get past the abnormal shutdown. Tried adding keys to the registry and that didn't help either. -Dan stanori wrote: Hi damcis, Sorry that you havent been contacted. It looks like we may have an old email address for you. (I just sent you a Private Msg so we can get a current email address) In regards to this issue, can you please verify that you are running the latest build of SQL Prompt: ftp://support.red-gate.com/patches/SQLP ... 3.6.28.zip Also, we will want to find out what OS and SSMS version you are running. Thanks, Steve [image] [image] [image] / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Lost sql prompt as addin to ssms
I'm running latest version of SQL Prompt. I can only tell that by trying to install it again. SSMS 2008 R2 on Window 7 64bit Also, it had been working before, but my pc crashed (had to shut it down...
0 votes
I was never contacted... stanori wrote: Hi damcis, Thanks for your post. We have created a support ticket for you in regards to this issue and will be contacting you shortly. Best Regards, Steve / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Lost sql prompt as addin to ssms
I was never contacted... stanori wrote: Hi damcis, Thanks for your post. We have created a support ticket for you in regards to this issue and will be contacting you shortly. Best Regards, Steve
0 votes
Lost sql prompt as addin to ssms
  1. Community
  2. SQL Prompt Previous Versions
My sql prompt is gone from SSMS. Tried to get it back by: Uninstalled all of sql server management studio and its components. Then uninstalled all of the red gate products (we own sql developers ...
4 followers 8 comments 0 votes
Just wanted to post a resolution to this problem. With Simon's help I figured out one of our tables was lacking a column datatype because it was being created on the fly every few minutes. A drop table was being called and then a select into with one of the columns defined like this: (MAX(rate_eff_dt)-1) As proposed_end_dt. The proposed end dt column had no datatype and caused sql prompt to fail to cache the database. I changed the sql job that called this script to explicitly create the table and then insert into table with a select. This fixed the problem. / comments
  1. Community
  2. SQL Prompt 4 Beta
  3. Unable to cache database objects
Just wanted to post a resolution to this problem. With Simon's help I figured out one of our tables was lacking a column datatype because it was being created on the fly every few minutes. A drop...
0 votes
Sure, I can provide a sql compare snapshot of our database. How should I send the file? / comments
  1. Community
  2. SQL Prompt 4 Beta
  3. Unable to cache database objects
Sure, I can provide a sql compare snapshot of our database. How should I send the file?
0 votes
Thanks for the query. It returns no results. / comments
  1. Community
  2. SQL Prompt 4 Beta
  3. Unable to cache database objects
Thanks for the query. It returns no results.
0 votes
I'm running a MS SQL Server 2008 Client against a MS SQL Server 2000 database. The error occurs repeatedly against one database. That query doesn't work. Invalid object name 'schemas'. Also, the schema wasn't changed while being cached. / comments
  1. Community
  2. SQL Prompt 4 Beta
  3. Unable to cache database objects
I'm running a MS SQL Server 2008 Client against a MS SQL Server 2000 database. The error occurs repeatedly against one database. That query doesn't work. Invalid object name 'schemas'. Also, the ...
0 votes
Unable to cache database objects
  1. Community
  2. SQL Prompt 4 Beta
Received this error after installation and opened up MS SQL Server Management Studio 2008 for the first time: Cannot retrieve objects from [database name]. Possible reasons: -insufficient memory to...
2 followers 8 comments 0 votes
Are there any plans for integrating SQL Prompt with Sybase's Powerbuilder product? Specifically their SQL IDE? Thanks. / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Version 4
Are there any plans for integrating SQL Prompt with Sybase's Powerbuilder product? Specifically their SQL IDE? Thanks.
0 votes
Total activity
14
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
4