How can we help you today? How can we help you today?
David Priddle
Activity overview Badges (0) Posts (2) Comments (214)

Comments

Sort by recent activity
Hi Larry, I think I may have misunderstood your post! There's a feature in SQL Prompt called Find Invalid Objects. Are you saying that you're writing a select statement in the query window, but Prompt is not providing suggestions for you? Are these newly created objects (created while you've had SSMS open)? If so, have you used Refresh Suggestions in the Prompt menu? Best regards, David / comments
  1. Community
  2. SQL Prompt
  3. Showing incorrectly that objects are invalid
Hi Larry, I think I may have misunderstood your post! There's a feature in SQL Prompt called Find Invalid Objects. Are you saying that you're writing a select statement in the query window, but Pro...
0 votes
Hi Larry, SQL Prompt requires a few more permissions for Find Invalid Objects to work correctly: Select Execute View Definition Set ShowPlan Set NoExec Create Trigger Create Procedure Create View Create Function Please let me know if this helps! If you have any more questions let me know. Best regards, David / comments
  1. Community
  2. SQL Prompt
  3. Showing incorrectly that objects are invalid
Hi Larry, SQL Prompt requires a few more permissions for Find Invalid Objects to work correctly: Select Execute View Definition Set ShowPlan Set NoExec Create Trigger Create Procedure Create View ...
0 votes
Hi Paul, Thanks for the bug report! We've managed to reproduce this here (it looks like it's not being recognised as a dependency). We've logged this issue internally with an ID of SP-5076. Best regards, David / comments
  1. Community
  2. SQL Prompt
  3. Found a bug in SQL Prompt 6.2.0.366
Hi Paul, Thanks for the bug report! We've managed to reproduce this here (it looks like it's not being recognised as a dependency). We've logged this issue internally with an ID of SP-5076. Best re...
0 votes
Hi bootieday, Unfortunately I can't run your code to reproduce this, as it depends on tblJC and Proc_TESTED_CODE. Can you confirm that you're using the latest 1.5 beta version of SQL Test? Best regards, David / comments
  1. Community
  2. SQL Test
  3. Why do SQL Test Messages appear doubled?
Hi bootieday, Unfortunately I can't run your code to reproduce this, as it depends on tblJC and Proc_TESTED_CODE. Can you confirm that you're using the latest 1.5 beta version of SQL Test? Best reg...
0 votes
Hi bootieday, We've just released a beta build of SQL Test that should fix your issue with the duplication of test results in the messages window: http://www.red-gate.com/MessageBoard/viewtopic.php?p=67784 Please let us know if this works for you! Best regards, David / comments
  1. Community
  2. SQL Test
  3. Why do SQL Test Messages appear doubled?
Hi bootieday, We've just released a beta build of SQL Test that should fix your issue with the duplication of test results in the messages window:http://www.red-gate.com/MessageBoard/viewtopic.php?...
0 votes
Hi bootieday, We're pleased to announce that we've just released a beta of SQL Test with additional SQLCop tests included: http://www.red-gate.com/MessageBoard/viewtopic.php?p=67784 Please let us know if you have any issues with the beta. Best regards, David / comments
  1. Community
  2. SQL Test
  3. Additional SQL Cop procs?
Hi bootieday, We're pleased to announce that we've just released a beta of SQL Test with additional SQLCop tests included:http://www.red-gate.com/MessageBoard/viewtopic.php?p=67784 Please let us kn...
0 votes
Good afternoon! Currently we don't have this feature, however it's is something that we are planning to do. We'll let you know when this is available! If you want to follow this feature, we have a UserVoice request here: https://redgate.uservoice.com/forums/94 ... semicolons Please let me know if you need any more information. Best regards, David Priddle / comments
  1. Community
  2. SQL Prompt
  3. How to enforce semicolon statement terminator
Good afternoon! Currently we don't have this feature, however it's is something that we are planning to do. We'll let you know when this is available! If you want to follow this feature, we have a ...
0 votes
Hi Iain, Thanks for responding! It's great to get feedback for our work, glad to hear it's all working ok! Please keep us informed! Best regards, David / comments
  1. Community
  2. SQL Test
  3. Long-running test crashes SSMS
Hi Iain, Thanks for responding! It's great to get feedback for our work, glad to hear it's all working ok! Please keep us informed! Best regards, David
0 votes
Hi Iain, I'm pleased to announce that we have a beta of SQL Test out that should fix all of the issues listed in your post: http://www.red-gate.com/MessageBoard/viewtopic.php?p=67784 Please let me know if you find any issues with this build. Best regards, David / comments
  1. Community
  2. SQL Test
  3. Long-running test crashes SSMS
Hi Iain, I'm pleased to announce that we have a beta of SQL Test out that should fix all of the issues listed in your post:http://www.red-gate.com/MessageBoard/viewtopic.php?p=67784 Please let me k...
0 votes
Hi Adam! We're pleased to say that we have just released a beta version of SQL Test which includes the latest version of the tSQLt framework: http://download.red-gate.com/EAP/SQLTes ... stBeta.zip To upgrade the tSQLt framework, right click on the database in the SQL Test window and click "Uninstall tSQLt Framework" and then reinstall it using "Add database...". None of your tests will be lost in the process. Please let us know if you have any issues. Best regards, David / comments
  1. Community
  2. SQL Test
  3. SQL Test is over a year behind tSQLt
Hi Adam! We're pleased to say that we have just released a beta version of SQL Test which includes the latest version of the tSQLt framework:http://download.red-gate.com/EAP/SQLTes ... stBeta.zip T...
0 votes
Total activity
320
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
104