How can we help you today? How can we help you today?
Chris Auckland
Activity overview Badges (0) Posts (7) Comments (611)

Comments

Sort by recent activity
You can multiselect all the alerts you want to clear in the UI, then right-click -> Clear Alert. / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. How to delete all alerts in a category
You can multiselect all the alerts you want to clear in the UI, then right-click -> Clear Alert.
0 votes
Thanks for your post. If you edit the Alert Template under 'configuration' in the UI, then you can disable the alerts you don't want to recieve. Any alerts that are already showing in the UI will need to be cleared. I hope this helps. / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. How to delete all alerts in a category
Thanks for your post. If you edit the Alert Template under 'configuration' in the UI, then you can disable the alerts you don't want to recieve. Any alerts that are already showing in the UI will n...
0 votes
Thanks for your post. I think I have managed to reproduce this. Can you make sure that the 'Comparison settings for script folders' is set to SQL Server 2000? You can set this in the 'Data sources' tab of project configuration, or confirm that it's set to version 8 in the RedGateDatabaseInfo.xml file. If it's set to 2005 or above, then the script parser is expecing a schema which causes the engine to get very confused. Can you check this and see if it helps? / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SQL Changeset with SQL Compare 8.0
Thanks for your post. I think I have managed to reproduce this. Can you make sure that the 'Comparison settings for script folders' is set to SQL Server 2000? You can set this in the 'Data sources'...
0 votes
I am running SQL Prompt 4.0.4.14 and have found that in some cases suggestions aren't showing up for temp tables. It looks like this is a bug with SQL Prompt 4. I have logged the case SP-2967. Thanks for bringing it to our attention. / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Temp tables and Suggestions Not Showing
I am running SQL Prompt 4.0.4.14 and have found that in some cases suggestions aren't showing up for temp tables. It looks like this is a bug with SQL Prompt 4. I have logged the case SP-2967....
0 votes
Hi Jonathan, I can't find a workaround for this, so I've logged it as a feature request for a future version. For your reference, our internal tracking code for the feature is SP-2964. Thanks for the suggestion. / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Code formatting to allow for SSMS parameters
Hi Jonathan, I can't find a workaround for this, so I've logged it as a feature request for a future version. For your reference, our internal tracking code for the feature is SP-2964. Thanks for t...
0 votes
Hi Jonathan, Thanks for the clarification. With the above example, the problem is that the SQL itself is not valid. The <Database_Name, sysname, Database_Name> statements cause parsing errors in SQL Prompt, Refactor and the SSMS parser. Once you modify the statement to state the database name, the SQL should parse and you will be able to lay-out the code. I hope this helps. / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Code formatting to allow for SSMS parameters
Hi Jonathan, Thanks for the clarification. With the above example, the problem is that the SQL itself is not valid. The <Database_Name, sysname, Database_Name> statements cause parsing errors in SQ...
0 votes
Hi Fatherjack, Is there any chance you could post a short script that reproduces the error? I just want to make sure I don't missunderstand what you're looking for. / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Code formatting to allow for SSMS parameters
Hi Fatherjack, Is there any chance you could post a short script that reproduces the error? I just want to make sure I don't missunderstand what you're looking for.
0 votes
This was answered via a private support ticket, but the advice was to use the same connection string as you would use to connect to the hosted server using SSMS. / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. any example of connection to remote server
This was answered via a private support ticket, but the advice was to use the same connection string as you would use to connect to the hosted server using SSMS.
0 votes
Not as far as I'm aware. Are you getting any specific issues? / comments
  1. Community
  2. SQL Source Control EAP
  3. Compatilble with SQL Server Management Studio 2008 Express?
Not as far as I'm aware. Are you getting any specific issues?
0 votes
Thanks for your post. Could you make sure you're on the latest version of SQL Source Control? (Help > Check for updates) Can you also send the file 'C:\Red Gate\SQL Source Control 0\workingBases\dfjkdsfjklsdljksdfjlkdsf\Tables\dbo.Customer.sql' to SQLSourceControlSupport@red-gate.com? We should then be able to recreate the problem here and hopefully provide a fix. / comments
  1. Community
  2. SQL Source Control EAP
  3. Error trying to apply updates to Trigger from TFS to DB
Thanks for your post. Could you make sure you're on the latest version of SQL Source Control? (Help > Check for updates) Can you also send the file 'C:\Red Gate\SQL Source Control 0\workingBases\df...
0 votes
Total activity
1052
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
434