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

Activity overview

Latest activity by theit8514

Error restoring empty log
  1. Community
  2. SQL Backup Previous Versions
I am experiencing an issue with restoring log files for a relatively inactive database. The database gets updates 3-4 times a day and the rest of the hourly log files have minimal transactions. Thi...
1 follower 1 comment 0 votes
Aaron Law wrote: Hi theit8514, I think I saw your request on UserVoice for this but could you explain the logic a bit more on when you'd expect us to ignore the dot as a completion key setting? Would it be only if the selected suggestion has a dot in it? I think that if the next character in the top suggestion is an insertion character (ie a dot in this case, but I can see a comma in the case of using a port number in a linked server), then that suggestion won't insert automatically. That would handle the case where you type 10./192./etc, but still handle wanting to autocomplete with a dot for a URL that is partially typed. / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 6.4 beta (Now closed)
Aaron Law wrote: Hi theit8514, I think I saw your request on UserVoice for this but could you explain the logic a bit more on when you'd expect us to ignore the dot as a completion key setting? ...
0 votes
Thanks Aaron, got your email reply. There is one other thing I was hoping you could look into. If you have the option set to trigger Insertions on the Dot key, the first linked server is expanded when trying to type an IP address. IE: Two linked server, 10.1.1.100 and 10.1.2.200. If I type "[10." the first server gets expanded automatically. In order for me to type most link server IP addresses I now have to press ESC before a dot. / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 6.4 beta (Now closed)
Thanks Aaron, got your email reply. There is one other thing I was hoping you could look into. If you have the option set to trigger Insertions on the Dot key, the first linked server is expanded w...
0 votes
Aaron Law wrote: Thanks for the extra info theit8514! I just saw your error report and it looks like it was the same thing bug that was causing the suggestion box to display a red X in the previous build, hopefully we have this fixed in 6.4.0.583. I'm sorry to hear you've hit other issues too, could you provide any more details on what you've hit? Thanks, Aaron. I have a long script which Prompt will not present any suggestions for Temporary tables after a certain point in the file. The script is an ALTER PROCEDURE script. I have my ParserLookBackDistance set to 30000, but it doesn't seem to be working. It recognizes that the temporary table exists, but when I try to access suggestions for the alias, nothing shows up. In addition, when I hover over the alias definition name, it shows "Unresolved alias (table)", whereas if I look at an actual table alias it shows "c (table)". Let me know if I need to submit the code for analysis. / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 6.4 beta (Now closed)
Aaron Law wrote: Thanks for the extra info theit8514! I just saw your error report and it looks like it was the same thing bug that was causing the suggestion box to display a red X in the previ...
0 votes
Aaron Law wrote: Hi theit8514, Thanks for letting us know about this. Unfortunately we're not able to recreate this locally at the moment so to help us in recreating it I wanted to check which version of windows you're running and also which .Net frameworks are installed on your VM? Also, can you think of anything else that we might need to do to trigger it here? Maybe connecting to a specific server or running multiple instances of SSMS? Thanks, Aaron. I am using Windows 8 and NET 4.5.1, running SSMS 2012. As for the triggers, I'm not really sure. I went back and reviewed the Event Log for application crashes and noted the 3 times that the application crashed, and then reviewed the SQL Prompt log files for those time periods and that warning message appeared each time. Other than that, it only happens after I have SSMS open for a long time, then close it. I have installed the latest version and am encountering a lot of other issues since doing so (I've submitted one through the bug reporter about an INNER JOIN crash), but have not yet experienced that issue again. / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 6.4 beta (Now closed)
Aaron Law wrote: Hi theit8514, Thanks for letting us know about this. Unfortunately we're not able to recreate this locally at the moment so to help us in recreating it I wanted to check which v...
0 votes
I'm not sure if this is related to SQL Prompt, but I installed the 537 version on the 27th and have had three crashes since then when closing SSMS. I have updated to the latest build, but wanted to report this anyways because I did not see anything in the change log mentioning it. In the SQL Prompt log, I get this warning message: 01 Sep 2014 06:07:17,217 [1] WARN RedGate.SQLQueryKeeper.TabWatcher - Exception trying to log document information System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.Shell.Interop.IVsPersistDocData'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{D5D49C61-1C0B-4EA1-9ADB-A79FB1DBC7B5}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). at Microsoft.VisualStudio.Platform.WindowManagement.DTE.DocumentWindow.get_DocData() at Microsoft.VisualStudio.Platform.WindowManagement.DTE.DocumentWindow.get_ObjectKind() at Microsoft.VisualStudio.Platform.WindowManagement.DTE.WindowBase.<get_ObjectKind>b__2a() at Microsoft.VisualStudio.Shell.ThreadHelper.Invoke[TResult](Func`1 method) at Microsoft.VisualStudio.Platform.WindowManagement.DTE.WindowBase.get_ObjectKind() at RedGate.SQLQueryKeeper.TabWatcher.LogDocumentInformation(Document document, Boolean documentClosing) And then once I close the application: Faulting application name: Ssms.exe, version: 2011.110.5058.0, time stamp: 0x537406e3 Faulting module name: KERNELBASE.dll, version: 6.2.9200.16864, time stamp: 0x531d2be6 Exception code: 0xc0020001 Fault offset: 0x00010f22 Faulting process id: 0x12e4 Faulting application start time: 0x01cfc64cf67abaf2 Faulting application path: C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe Faulting module path: C:\Windows\SYSTEM32\KERNELBASE.dll Report Id: 1cbc2309-32cf-11e4-be79-000c295d77cf Faulting package full name: Faulting package-relative application ID: I only have the developer bundle installed, no other extensions. I do not get the Red-Gate exception dialog appearing. The only indicator is SSMS restarting. Edit: well, I may be going crazy. I'm in the middle of rebuilding my development machine VM and this error cropped up on the new machine. The crash shows up in the Event log on the old VM, but I don't remember seeing it. I think maybe I have it configured to not restart crashed applications. / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 6.4 beta (Now closed)
I'm not sure if this is related to SQL Prompt, but I installed the 537 version on the 27th and have had three crashes since then when closing SSMS. I have updated to the latest build, but wanted to...
0 votes
I am no longer able to get a list of parameters for a procedure when positioned directly after a procedure call or a comma after the last parameter of a procedure call. http://i.imgur.com/Phq5gWk.png Running 6.4.0.404 (went back to 6.3 to test if that feature was there and it appears it was http://i.imgur.com/W0qVc7H.png) / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 6.4 beta (Now closed)
I am no longer able to get a list of parameters for a procedure when positioned directly after a procedure call or a comma after the last parameter of a procedure call. http://i.imgur.com/Phq5gWk.p...
0 votes
Total activity
8
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1