Comments
Sort by recent activity
Thanks for the query.
It returns no results. / comments
Thanks for the query.
It returns no results.
Sure, I can provide a sql compare snapshot of our database.
How should I send the file? / comments
Sure, I can provide a sql compare snapshot of our database.
How should I send the file?
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
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...
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
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 ...
Are there any plans for integrating SQL Prompt with Sybase's Powerbuilder product? Specifically their SQL IDE?
Thanks. / comments
Are there any plans for integrating SQL Prompt with Sybase's Powerbuilder product? Specifically their SQL IDE?
Thanks.
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
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...
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
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...
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
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