How can we help you today? How can we help you today?
jerryhung
Activity overview Badges (0) Posts (23) Comments (83)

Comments

Sort by recent activity
I had 3.8 RC installed (forgot what version, or trial?) Installed 3.8 by using "Check Update" it defaults to Standard version as well as I noticed the "Layout" item greyed out Activated it again using my Toolbelt key, and it is Pro version now / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. 3.8 Pro
I had 3.8 RC installed (forgot what version, or trial?) Installed 3.8 by using "Check Update" it defaults to Standard version as well as I noticed the "Layout" item greyed out Activated it again us...
0 votes
tanya wrote: Hi, I am glad that you both liked the object definition feature that we introduced in v3.8 [image] And yeah, the current SQL Prompt parser gives valid intellisense only when the SQL syntax in the query window is complete and devoid of any errors. But flagging the errors is a great suggestion. I have logged this as an enhancement request that we will review and probably implement for our future versions. Thank you for taking the time to write your thoughts. Regards, Tanya You guys could do what SSMS 2008 does, red underline the incorrect syntax error, just like a spell checker I noticed these when I used SSMS 2008 yesterday, but its IntelliSense isn't near SQL Prompt of course / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. SQL Prompt 3.8.0.24
tanya wrote: Hi, I am glad that you both liked the object definition feature that we introduced in v3.8 And yeah, the current SQL Prompt parser gives valid intellisense only when the SQL syntax...
0 votes
All good now So I uninstalled SQL Prompt, SQL Refactor, SQL 2005 (inc. VS2005) Re-install everything again – SQL 2005 (Client tools only), SP2, SQL Prompt And voila! It works, Layout function work as well. Used it for 2 days no issue Installed SSMS Tools today, and it still seems to work, YEH!!!! Thanks for all the help / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. SQL Prompt 3.8RC Layout SQL error
All good now So I uninstalled SQL Prompt, SQL Refactor, SQL 2005 (inc. VS2005) Re-install everything again – SQL 2005 (Client tools only), SP2, SQL Prompt And voila! It works, Layout function wo...
0 votes
SSMS Tools removed, same error and my SQL Prompt doesn't work in VS2005, doesn't show on tool menu in VS2008 I think this is the sequence I had had SQL Toolbelt with SSMS, SQL Refactor works occasionally installed Data Compare 7 beta, SQL Prompt 3.8RC when they came out installed SQL Response, SQL Data Generator Prompt wasn't working, uninstalled entire Toolbelt, re-installed, now it's in a very messy situation....will try to find a clean machine to try System.ApplicationException: Exception within progress task ---> System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.TextManager.Interop.IVsTextView'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{BB23A14B-7C61-469A-9890-A95648CED5E6}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). at Microsoft.VisualStudio.TextManager.Interop.IVsTextView.GetSelection(Int32& piAnchorLine, Int32& piAnchorCol, Int32& piEndLine, Int32& piEndCol) at RedGate.SQLPrompt.CommonVS.Editor.VSEditorWindow.get_Selection() at RedGate.SQLPrompt.CommonUI.Refactor.Refactor.a(EditorWindowBase , b , c& ) at RedGate.SQLPrompt.CommonUI.Refactor.Refactor.a(EditorWindowBase , c& , b[] ) at RedGate.SQLPrompt.CommonUI.Refactor.Refactor.a.Run() at RedGate.SQLPrompt.CommonUI.Progress.TaskAggregator.Run() at RedGate.SQLPrompt.CommonUI.Forms.ProgressDialogue.a() --- End of inner exception stack trace --- at RedGate.SQLPrompt.CommonUI.Forms.ProgressDialogue.ShowProgress(ITaskRunner task) at RedGate.SQLPrompt.CommonUI.Refactor.Refactor.LayOutSql(EditorWindowBase editor, SqlPromptOptions options) at b.Execute() at RedGate.SQLPrompt.CommonVS.Commands.VSCommandControler.Exec(String CmdName, vsCommandExecOption ExecuteOption, Object& VariantIn, Object& VariantOut, Boolean& Handled) Easier if I can send the rgdias.txt to someone Platform : Win32NT Service Pack : Service Pack 2 Network : True Caption : Microsoft Windows XP Professional Version : 5.1.2600 | | ---------- | | SQL Backup | | ---------- | | | - | | | 5 | | | - | | | | CurrentVersion: 5.1.0.0 | | ----------- | | SQL Compare | | ----------- | | | - | | | 6 | | | - | | | | CurrentVersion: 6.2.0.0 | | | - | | | 7 | | | - | | | | CurrentVersion: 7.0.0.392 | | ---------------- | | SQL Data Compare | | ---------------- | | | - | | | 6 | | | - | | | | CurrentVersion: 6.1.1.308 | | ------------------ | | SQL Data Generator | | ------------------ | | | - | | | 1 | | | - | | | | CurrentVersion: 1.0.0.1022 | | ------- | | SQL Doc | | ------- | | | - | | | 1 | | | - | | | | CurrentVersion: 1.02.0031.0 | | -------------- | | SQL Log Rescue | | -------------- | | | Currentversion: 1.20.0010.0 | | ---------------- | | SQL Multi Script | | ---------------- | | | - | | | 1 | | | - | | | | CurrentVersion: 1.1.0.34 | | ------------ | | SQL Packager | | ------------ | | | - | | | 5 | | | - | | | | CurrentVersion: 5.4.0.0 | | ---------- | | SQL Prompt | | ---------- | | | - | | | 3 | | | - | | | | CurrentVersion: 3.80.0.1 | | ----------- | | SQL Tracker | | ----------- | | | - | | | 2 | | | - | | | | CurrentVersion: 2.40.0075.0 / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. SQL Prompt 3.8RC Layout SQL error
SSMS Tools removed, same error and my SQL Prompt doesn't work in VS2005, doesn't show on tool menu in VS2008 I think this is the sequence I had had SQL Toolbelt with SSMS, SQL Refactor works occas...
0 votes
Any query gives me that error when I do Layout in 3.8RC if someone can create a support ticket for me that's better I have a .txt file from your Diagnostic Tool to send It's annoying, I always run into odd cases of Layout products another support ticket F0010024 is SSMS Tools & SQL Refactor this one, somehow SSMS, SQL Refactor, SQL Prompt 3.6, SQL Prompt 3.8 altogether, install & uninstall, creates problem again [image] plus, 3.8RC doesn't auto-prompt anymore unless I hit Ctrl+Space, despite it's set to auto-complete I need a Virtual Machine image..................... thanks, I like the product thus far / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. SQL Prompt 3.8RC Layout SQL error
Any query gives me that error when I do Layout in 3.8RC if someone can create a support ticket for me that's better I have a .txt file from your Diagnostic Tool to send It's annoying, I always run ...
0 votes
You mean CTRL-K, CTRL-Y for Layout in SQL Prompt? CTRL+B, CTRL+L is for SQL Refactor SQL Refactor "hangs" my SSMS, so I uninstalled it and don't use it anymore for SQL Prompt, I had to uninstall EVERYTHING, re-install SQL2005, etc... to get it to work (but it was only returning exceptions instead of "crash" my SSMS) / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. prompt crashes visual studio
You mean CTRL-K, CTRL-Y for Layout in SQL Prompt? CTRL+B, CTRL+L is for SQL Refactor SQL Refactor "hangs" my SSMS, so I uninstalled it and don't use it anymore for SQL Prompt, I had to uninstall EV...
0 votes
Andras wrote: Many thanks for all your comments. We have now added an option to add a use statement at the beginning of a script generated by SQL Compare 7. This option will be off by default. Regards, Andras THANK YOU / comments
  1. Community
  2. SQL Compare 7 Beta
  3. FEATURE REQUEST: Add a USE DB_NAME statement
Andras wrote: Many thanks for all your comments. We have now added an option to add a use statement at the beginning of a script generated by SQL Compare 7. This option will be off by default. R...
0 votes
I understand your logic completely I would prefer it to be an OPTION as well instead of by default Thanks for considering it / comments
  1. Community
  2. SQL Compare 7 Beta
  3. FEATURE REQUEST: Add a USE DB_NAME statement
I understand your logic completely I would prefer it to be an OPTION as well instead of by default Thanks for considering it
0 votes
That explains it, I thought SQL Compare 7 wasn't saving the project files Yes I did read that part on the release thread just didn't realize 6.0 cannot read 7.0 Projects now I have 6.0 and 7.0 Projects folder, it's fine now / comments
  1. Community
  2. SQL Compare 7 Beta
  3. Bug? Open Project View missing Server/DB names
That explains it, I thought SQL Compare 7 wasn't saving the project files Yes I did read that part on the release thread just didn't realize 6.0 cannot read 7.0 Projects now I have 6.0 and 7.0 Proj...
0 votes
so is it not preferable to have a test SQL server with payroll+custom database? or like you said separate instance that way SPs won't need to be changed / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Creating mulitple test databases -- can SQL Compare help?
so is it not preferable to have a test SQL server with payroll+custom database? or like you said separate instance that way SPs won't need to be changed
0 votes
Total activity
170
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
64