Comments
Sort by recent activity
Thanks for your post Mike.
You can do the following to ensure that SQL Prompt will not re-appear in the menu for VS upon startup:
1) Open up VS and go to Tools > Add In Manager
2) Uncheck SQL Prompt both as an available add in and startup, click ok
3) Go to Tools > Customize
4) Drag the SQL Prompt menu icon away from the menu bar, and it should disappear.
5) Restart VS, and SQL Prompt should be gone from there, but not SSMS
Kindly let me know if this fixes the issue. / comments
Thanks for your post Mike.
You can do the following to ensure that SQL Prompt will not re-appear in the menu for VS upon startup:
1) Open up VS and go to Tools > Add In Manager
2) Uncheck SQL Promp...
Thanks for your post regspc and apologies for the inconvenience caused by SQL Prompt 4.
I have logged this in our internal tracking system so that our development guys can look into it and incorporate this feature in our future release.
Tracking Id for this issue is SP-2898.
Kindly let us know if you have any other issues or questions regarding the product,I'll like to help. / comments
Thanks for your post regspc and apologies for the inconvenience caused by SQL Prompt 4.
I have logged this in our internal tracking system so that our development guys can look into it and incorpor...
Thanks for your post.
Unfortunately SQL Compare doesn't display a difference if the trigger is enabled on one database and not on another.
Displaying the difference in trigger status is currently on the wishlist for SQL Compare, and will hopefully be added to a future version. The feature tracking code for this is SC-3996.
As a workaround, you can query the status of all triggers on a database using the following:
SELECT T.[name] as TableName, TR.[Name] as TriggerName,
CASE WHEN 1=OBJECTPROPERTY(TR.[id], 'ExecIsTriggerDisabled')THEN 'Disabled' ELSE 'Enabled' END Status
FROM sysobjects T INNER JOIN sysobjects TR on t.[ID] = TR.parent_obj WHERE (T.xtype = 'U' or T.XType = 'V')
AND (TR.xtype = 'TR') ORDER BY T.[name], TR.[name]
I hope this is helpful. / comments
Thanks for your post.
Unfortunately SQL Compare doesn't display a difference if the trigger is enabled on one database and not on another.
Displaying the difference in trigger status is currently o...
Many thanks for your post.
Can you kindly let us know which time column are you refering to is it Time (ms) or Time with Children (ms)?
Above information will help us to investigate further. / comments
Many thanks for your post.
Can you kindly let us know which time column are you refering to is it Time (ms) or Time with Children (ms)?
Above information will help us to investigate further.
Kindly let me know if you need link to download the same. / comments
Kindly let me know if you need link to download the same.
Thanks for your post.
This issue was fixed in our latest version (4.0.3.10) can you kindly let me know which version are you using?
You can know the detailed version of SQL Prompt by navigating to SQL Prompt --> About SQL Prompt and version number is displayed on bottom right. / comments
Thanks for your post.
This issue was fixed in our latest version (4.0.3.10) can you kindly let me know which version are you using?
You can know the detailed version of SQL Prompt by navigating to ...
Hello All,
Many thanks for your patience regarding this issue.
I am pleased to inform you that we have fixed the SQL Prompt issue you were experiencing in our latest patch.
Kindly check the forum post to download the version: https://www.red-gate.com/messageboard/v ... hp?t=10248
Please let us know if this fixes your issue. / comments
Hello All,
Many thanks for your patience regarding this issue.
I am pleased to inform you that we have fixed the SQL Prompt issue you were experiencing in our latest patch.
Kindly check the forum p...
Many thanks for your post Michael.
As per steps provided by you I tried to replicate the issue but it works fine for me.
Can you kindly email me the screenshot of the settings: SQL Prompt 4 --> Options --> Inserted Code --> Special Characters ? / comments
Many thanks for your post Michael.
As per steps provided by you I tried to replicate the issue but it works fine for me.
Can you kindly email me the screenshot of the settings:SQL Prompt 4 --> Opti...
Apologies for the inconvenience caused by this.
I have logged this issue in our internal tracking system (SP-2875) so that our development team can have a look at it.
Kindly let me know if you have any other issues or questions regarding this issue. / comments
Apologies for the inconvenience caused by this.
I have logged this issue in our internal tracking system (SP-2875) so that our development team can have a look at it.
Kindly let me know if you have...
Many thanks for your post and apologies for the inconveninece caused by this issue.
Can you kindly email us the script?
Note: We have generated a call reference for you which is F0028882 kindly add this reference number in your subject line. / comments
Many thanks for your post and apologies for the inconveninece caused by this issue.
Can you kindly email us the script?
Note: We have generated a call reference for you which is F0028882 kindly add...