How can we help you today? How can we help you today?
Bart Read
Activity overview Badges (0) Posts (45) Comments (935)

Comments

Sort by recent activity
That would be my suggestion as well Mike: try giving it a go from a different machine. Sorry, I realise it's slightly lame. Thanks, Bart / comments
  1. Community
  2. ANTS Performance Profiler Previous Versions
  3. Survey Problems
That would be my suggestion as well Mike: try giving it a go from a different machine. Sorry, I realise it's slightly lame. Thanks, Bart
0 votes
Hi Mike, Sorry for the delay getting back to you. We had another user report a similar problem. Could you let me know which anti-virus software you're using please? Thanks, Bart / comments
  1. Community
  2. ANTS Performance Profiler Previous Versions
  3. Survey Problems
Hi Mike, Sorry for the delay getting back to you. We had another user report a similar problem. Could you let me know which anti-virus software you're using please? Thanks, Bart
0 votes
Hello there, Apologies for the inconvenience. Please follow the instructions here: http://help.red-gate.com/help/SQLPrompt ... lling.html Thanks, Bart / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Management Studio Menus
Hello there, Apologies for the inconvenience. Please follow the instructions here:http://help.red-gate.com/help/SQLPrompt ... lling.html Thanks, Bart
0 votes
Hi Dan, Thanks for your enquiry. I'm afraid the answer is that at present we have no plans to support the Powerbuilder development environment. Thanks, Bart / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Version 4
Hi Dan, Thanks for your enquiry. I'm afraid the answer is that at present we have no plans to support the Powerbuilder development environment. Thanks, Bart
0 votes
Hi there, Please try this. In your editor click on SQL Prompt > Options (on the main menu bar). Now go to Listed Candidates > Performance and increase the value of "Search a fixed number of lines from the caret" from 50 up to say 200 or 300. If you don't notice any performance hit you might even want to increase this further. If this doesn't fix your problem please let us know. Thanks, Bart / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. columns not available in stored procedure
Hi there, Please try this. In your editor click on SQL Prompt > Options (on the main menu bar). Now go to Listed Candidates > Performance and increase the value of "Search a fixed number of lines f...
0 votes
Hi Brian, OK thanks, that's good to know. I had a chat with Tanya earlier as well, and since this is obviously a workaround rather than a fix we've still got a developer looking at it now. If you run into anything else please let us know. The feedback is always welcome. Cheers, Bart / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. INFORMATION_SCHEMA - Beyond Glitch!
Hi Brian, OK thanks, that's good to know. I had a chat with Tanya earlier as well, and since this is obviously a workaround rather than a fix we've still got a developer looking at it now. If you r...
0 votes
Hi Brian, Sorry for the delay. We are spending time on this at the moment, although please feel free to mail support@red-gate.com to get a ticket assigned. The Prompt team is new to the job this past month or so, so it's taking them a while to get to grips with things. I've actually tried debugging this but (typically) it's a Heisenbug: happens with 100% reproducibility until you attach a debugger, when it disappears completely. I suspect some sort of race condition because we populate the system objects differently for SQL Server 7/2000 versus 2005/2008. For 2005 and beyond it's easy: all the system catalog stuff is exposed in all databases, so we just read the meta-data for the database you're connecting to and all the system objects come for free. Unfortunately this doesn't work for SQL Server 7 and 2000. In this case we have to also load the master database and merge the objects into the collections for your current database. Somewhere in the midst of the merging the INFORMATION_SCHEMA objects are getting lost. At the moment I'm just not sure where. I have a suspicion that as soon as we've found the problem it'll be a fairly straightforward fix, but at the moment it's not obvious what's going wrong. I'll let you know when we have anything else, and apologies again for the delay. Thanks, Bart / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. INFORMATION_SCHEMA - Beyond Glitch!
Hi Brian, Sorry for the delay. We are spending time on this at the moment, although please feel free to mail support@red-gate.com to get a ticket assigned. The Prompt team is new to the job this pa...
0 votes
Oops, looks like I spoke too soon there. Apparently this has been fixed, which is great. Thanks, Bart / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. INFORMATION_SCHEMA - Beyond Glitch!
Oops, looks like I spoke too soon there. Apparently this has been fixed, which is great. Thanks, Bart
0 votes
Hi Brian, That's really odd. I've just got the same thing here. If I'm connected to master (on SQL Server 2000) then I can access everything in INFORMATION_SCHEMA no problem, but if I'm connected to any other database, such as Northwind, I can see the INFORMATION_SCHEMA object itself, but none of the views belonging to it. My apologies for this. Please bear with us and we'll take some time to look into it. Thanks, Bart / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. INFORMATION_SCHEMA - Beyond Glitch!
Hi Brian, That's really odd. I've just got the same thing here. If I'm connected to master (on SQL Server 2000) then I can access everything in INFORMATION_SCHEMA no problem, but if I'm connected t...
0 votes
No problem. / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Register S/N
No problem.
0 votes
Total activity
1504
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
524