Comments
Sort by recent activity
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...
We did have a similar issue with QUOTED_IDENTIFIER in a previous version of SQL Compare (http://www.red-gate.com/messageboard/vi ... php?t=2182)
However, this should have been fixed in version 7. Which version are you experiencing this issue with? / comments
We did have a similar issue with QUOTED_IDENTIFIER in a previous version of SQL Compare (http://www.red-gate.com/messageboard/vi ... php?t=2182)
However, this should have been fixed in version 7. W...
I'm sorry that you've experienced these problems. We are aware that there is an issue with mapping in version 7.1 of SQL Data Compare and so the developers have produced a private patch which should address this. I've pm'd you with the link to the download.
(Anyone else having mapping issues in version 7.1 should get in touch with support - support@red-gate.com - who will be able to provide you with the link to the patch) / comments
I'm sorry that you've experienced these problems. We are aware that there is an issue with mapping in version 7.1 of SQL Data Compare and so the developers have produced a private patch which shoul...
Thanks for your feedback. SQL Prompt should work as you wish. When using a user defined function SQL Prompt should prompt you with the parameters needed for that function. This should happen in the way that you describe, as you type the parameters and then a comma SQL Prompt should move to the next parameter in the tooltip. If you do a simple test with an Adventureworks function you should see this e.g.
SELECT dbo.ufnGetProductDealerPrice()
When you place the cursor in the (), SQL Prompt should highlight the first parameter needed and then move onto the next one after you type a comma. Does this work for you?
If this works but you're still having issues with a certain function could you give me an example? / comments
Thanks for your feedback. SQL Prompt should work as you wish. When using a user defined function SQL Prompt should prompt you with the parameters needed for that function. This should happen in the...
Do you still need assistance with this posting or have you been able to get the parameter prompting working? / comments
Do you still need assistance with this posting or have you been able to get the parameter prompting working?
Thanks for the feedback. I've added this to our list of feature requests for the product team to consider implementing in the next release of SQL Prompt.
For your reference the feature request tracking code is: SP-1397 / comments
Thanks for the feedback. I've added this to our list of feature requests for the product team to consider implementing in the next release of SQL Prompt.
For your reference the feature request trac...
I've created a linked server using exactly the same script as you provided (adding an IP address of a SQL Server on my network). However, I can't recreate your issue. When I first referenced the linked server it asked for authentication and I chose 'Do not Connect' and that was it no other authentication dialogs appeared. I also went through the process again and added the server to the 'Connection to Ignore' and it functioned as expected. Where in the script does this issue occur? When you open a clean query window and type a simple statement incorporating the linked server do you still experience the issue? Or does it seem to occur when working with a large complex script? Which version of SQL Server are the two servers? Are there any other patterns that you have seen that relate to this issue? / comments
I've created a linked server using exactly the same script as you provided (adding an IP address of a SQL Server on my network). However, I can't recreate your issue. When I first referenced the li...
I have seen this issue occur before due to differences in case. Currently SQL Prompt is case sensitive when it comes to adding to the 'Connections to Ignore'. Could you make sure that the entry in the 'Connections to Ignore' settings is written exactly the same (including case) as the server mentioned in the Authentication pop-up?
If this doesn't work could you give me a little more information about the Linked server? Is it another SQL Server and is the 'SQL Server' radio button checked in the linked server's general properties? / comments
I have seen this issue occur before due to differences in case. Currently SQL Prompt is case sensitive when it comes to adding to the 'Connections to Ignore'. Could you make sure that the entry in ...
Does SQL Compare show the object in the top comparison result pane under the heading 'x objects that exist in both but are different'?
The differences in layout could well be shown in the bottom 'SQL Differences' pane, as this will show all textual differences. However, this shouldn't lead to the objects being shown in the top pane as being different. If the object is being shown in the top pane as having differences could you double check that it isn't in fact another 'real' difference that is causing this.
If you're sure that it's the layout that is causing the object to be seen as different could you send me the sql creation script for the two objects, so that I can look into it?
You can send the scripts to support@red-gate.com and quote reference: F0015858 / comments
Does SQL Compare show the object in the top comparison result pane under the heading 'x objects that exist in both but are different'?
The differences in layout could well be shown in the bottom 'S...