User profile for Sian.Williams

Thanks for your question. If you go to your SQL Prompt tab within SSMS, click options > types of suggestion and make sure the 'list system objects' box is checked. Then go back to the SQL Prompt tab > Refresh Suggestions. Now when you type sp_helptext it should give you the same options as EXEC sp_helptext. I hope this helps. / comments

Thanks for your question. If you go to your SQL Prompt tab within SSMS, click options > types of suggestion and make sure the 'list system objects' box is checked. Then go back to the SQL Prompt ta...

0 votes

Hi Kevin, I don't think this has been requested yet, but I have added a feature request for you. The request id is SC-5123 if you wish to chase it up in the future. Thanks, / comments

Hi Kevin, I don't think this has been requested yet, but I have added a feature request for you. The request id is SC-5123 if you wish to chase it up in the future. Thanks,

0 votes

Thanks for contacting Red Gate. The error is unfortunately quite vague, but it does look like it might be a bug, and may quite likely have been fixed in v9. Would you be able to download a trial version of v9 to see if it helps? I will email you a trial key for this, you need to deactivate SQL Compare 8, download and install a trial copy of SQL Compare 9, then reactivate using the trial code. Thanks / comments

Thanks for contacting Red Gate. The error is unfortunately quite vague, but it does look like it might be a bug, and may quite likely have been fixed in v9. Would you be able to download a trial ve...

0 votes

Thanks for your question. I don't think there is a way of 'testing' the script, however, when you run the synchronisation wizard, if you click 'Synchronise using SQL Compare' and then check the box which says 'Back up target before synchronisation' which will create a SQL Compare snapshot of your databases or allow you to perform a backup at the end of the wizard. / comments

Thanks for your question. I don't think there is a way of 'testing' the script, however, when you run the synchronisation wizard, if you click 'Synchronise using SQL Compare' and then check the box...

0 votes

Thanks for contacting Red Gate. I'm fairly sure that v7 has this option, but if you click the options tab when you create a new project, you can check the box for 'do not use transactions in synchronisation scripts'. This should stop you getting that error, however, something to bear in mind is that it wont roll back if the script fails so you need to make sure you're happy with it before you synchronise. I hope this answers your question, if you're unsure whether or not you are eligible for more recent versions of the tool, give is a call and speak to the sales team, or you can email sales@red-gate.com. I hope this helps. Thanks. / comments

Thanks for contacting Red Gate. I'm fairly sure that v7 has this option, but if you click the options tab when you create a new project, you can check the box for 'do not use transactions in synchr...

0 votes

Thanks for your questions. This document has some tips that could help you [image] http://www.red-gate.com/supportcenter/C ... %20Tracker / comments

Thanks for your questions. This document has some tips that could help you http://www.red-gate.com/supportcenter/C ... %20Tracker

0 votes

Thanks for your comments. This has already been requested by other users, it has been logged as DT-577 if you wish to chase it up in the future. I will add your comments to the request [image] Thanks / comments

Thanks for your comments. This has already been requested by other users, it has been logged as DT-577 if you wish to chase it up in the future. I will add your comments to the request Thanks

0 votes

Thanks for your question, I'm sorry you're having some trouble with SQL Backup. Are you connecting to this particular server over a network? If so it may be an issue with your network. Thanks / comments

Thanks for your question, I'm sorry you're having some trouble with SQL Backup. Are you connecting to this particular server over a network? If so it may be an issue with your network. Thanks

0 votes

How can we help you today?

Sian.Williams

Comments