Comments
Sort by recent activity
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...
We worked on this issue and it seems that turning off the option to support 'linked servers' resolved the issue. Something to do with the linked server was triggering the Windows Authentication errors in the background. We are going to look into this to see if there's anything we can do to prevent these from occurring in the future. / comments
We worked on this issue and it seems that turning off the option to support 'linked servers' resolved the issue. Something to do with the linked server was triggering the Windows Authentication err...
I think that the following document should help answer your question - http://www.red-gate.com/supportcenter/C ... onTags.htm
You can add tags to your backup location to add a datetime stamp. For example if you want your backups to go to separate folders based on datetime you can make the path similar to the following:
C:\Backups\<DATETIME yyyymmdd>\<database>.sqb
This would save your full backups in a folder named the date that they were created and the backup file would be named the same as the database backed up e.g.
C;\Backups\20080929\Adventureworks.sqb / comments
I think that the following document should help answer your question -http://www.red-gate.com/supportcenter/C ... onTags.htm
You can add tags to your backup location to add a datetime stamp. For ex...