Comments
Sort by recent activity
Unfortunately, in it's current incarnation SQL Prompt doesn't support 2008 spacial data functions. However, the developers are working on SQL Prompt 4 as we speak and I've raised a feature request to support these methods and functions in this future version. This isn't due for release until Q2 2009.
For your reference the feature tracking code is: SP-1526 / comments
Unfortunately, in it's current incarnation SQL Prompt doesn't support 2008 spacial data functions. However, the developers are working on SQL Prompt 4 as we speak and I've raised a feature request ...
I'm sorry that you're experiencing these issues. Could you try entering the specific database name in the 'Connections to Ignore' options. So instead of choosing 'All databases' type in 'PWGDUM'. I know that this isn't going to resolve the issue if you have multiple databases on that particular server referenced. But I'd like to know whether explicitly stating the database name makes a difference. / comments
I'm sorry that you're experiencing these issues. Could you try entering the specific database name in the 'Connections to Ignore' options. So instead of choosing 'All databases' type in 'PWGDUM'. I...
Thank you for your feedback. This seems to be an issue that quite a few users hit as the synchronization scripts can grow to an unmanageable size. This is already logged as a feature request in our tracking software and it is something that I'm hoping that we are going to be able to implement in a future version of SQL Data Compare.
For your reference the feature tracking code is: SDC-771 / comments
Thank you for your feedback. This seems to be an issue that quite a few users hit as the synchronization scripts can grow to an unmanageable size. This is already logged as a feature request in our...
The code layout functionality allows you to layout your sql code and customize the way that it looks. This can help to make the code more readable or can be used to keep the layout of code consistent across a team. For details you can look at the help file which goes into more depth - http://www.red-gate.com/supportcenter/C ... c52128.htm / comments
The code layout functionality allows you to layout your sql code and customize the way that it looks. This can help to make the code more readable or can be used to keep the layout of code consiste...
Sorry that it's taken a while for someone to answer you. Could you try granting the user the VIEW SERVER STATE permission? Sometimes, if SQL Prompt needs to grab information regarding encryption keys this error can be returned if the user does not have this privilege. / comments
Sorry that it's taken a while for someone to answer you. Could you try granting the user the VIEW SERVER STATE permission? Sometimes, if SQL Prompt needs to grab information regarding encryption ke...
Unfortunately, there isn't a way to delay the speed that the tooltips appear. However, you can turn them off if they're interfering with the way you work. Go to 'SQL Prompt' > 'Options' > Behaviour > 'Information Panels', 'Enable object definition hints' and 'Enable parameter hints'.
I hope that helps. / comments
Unfortunately, there isn't a way to delay the speed that the tooltips appear. However, you can turn them off if they're interfering with the way you work. Go to 'SQL Prompt' > 'Options' > Behaviour...
Is there any more information presented in the exception window? Do you have the option to debug and see the stack trace? If not, is there any more information held in the Windows Event Viewer application logs? / comments
Is there any more information presented in the exception window? Do you have the option to debug and see the stack trace? If not, is there any more information held in the Windows Event Viewer appl...
Ok I apologise, I've tried it again and I do get the same outcome as you (I'm not sure why it wasn't working for me first of all. Probably a silly typing error!).
Once you've typed the variable manually, SQL Prompt does recognise it and give you the object hint information. So there is a part of SQL Prompt that does recognise it, after it's been typed.
The developers are working on SQL Prompt 4 at the moment and completely rewriting the parser. These inconsistencies are what they're concentrating on ironing out. So I've logged this as a bug in our bug tracking software and this will be tested against the SQL Prompt 4 build.
For your reference the bug tracking code is: SP-1482 / comments
Ok I apologise, I've tried it again and I do get the same outcome as you (I'm not sure why it wasn't working for me first of all. Probably a silly typing error!).
Once you've typed the variable man...
Could you just confirm that when you manually type the variable in your code i.e.
AND ( ([RegionGUID] = @RegionGuid AND @XXX)
, you can successfully parse the SQL code using SQL Server? I've recreated this and when I have the following line as
..
AND ( ([RegionGUID] = @RegionGuid)
..
it parses successfully. However, as soon as I add the 'AND' and the second variable I get an 'Incorrect syntax' returned. / comments
Could you just confirm that when you manually type the variable in your code i.e.
AND ( ([RegionGUID] = @RegionGuid AND @XXX)
, you can successfully parse the SQL code using SQL Server? I've recrea...
I contacted the user through our support channels and he was able to resolve the issue while gathering information to send to me.
It seemed that the comparison options had the Ignore 'SET QUOTED_IDENTIFIER and SET ANSI_NULLS statements' option ticked. Once this was unchecked the comparison ran as expected. If anyone else encounters this issue please try the resolution above. If this doesn't work and you require assistance please contact our support team at support@red-gate.com / comments
I contacted the user through our support channels and he was able to resolve the issue while gathering information to send to me.
It seemed that the comparison options had the Ignore 'SET QUOTED_ID...