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

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

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 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

Thanks for your question. SQL Data Compare 8 includes the WHERE clause in the update scripts. This causes issues if it selects from another table and that table hasn't been updated yet. It's not easy to tell when this is going to happen. SQL Data Compare 9 doesn't seem to have this issue, it may be worth upgrading/evaluating it if you haven't done so already. I hope this helps. / comments

Thanks for your question. SQL Data Compare 8 includes the WHERE clause in the update scripts. This causes issues if it selects from another table and that table hasn't been updated yet. It's not ea...

0 votes

Thanks for your question, unfortunately this isn't a SQL Source Control issue, the best people to ask would be the people who deal with SVN directly. Alternatively, you could post a question here: http://fogbugz.stackexchange.com/ You could try having a look here: http://fogbugz.stackexchange.com/questi ... ntegration http://www.fogcreek.com/fogbugz/docs/40 ... nScri.html Other than that there isn't much else I can suggest but they should be able to help. Thanks, / comments

Thanks for your question, unfortunately this isn't a SQL Source Control issue, the best people to ask would be the people who deal with SVN directly. Alternatively, you could post a question here:h...

0 votes

How can we help you today?

Sian.Williams

Activity overview