Comments
Sort by recent activity
Unfortunately, if you use the GUI to set up log shipping it will always want to backup the source database, send it over the network and restore it on the destination. This is by design as most users using the wizard will require this to be done.
We will look into the possibility of allowing users to manually set-up their destination database for future releases.
The only way to workaround this would be to set the jobs up manually. If you set up a log shipping job with a small database, you can go to the SQL Server Agent jobs, find the backup and restore jobs and copy and edit these to reflect your main database. For more information regarding the log shipping process see - http://www.red-gate.com/MessageBoard/vi ... g+shipping / comments
Unfortunately, if you use the GUI to set up log shipping it will always want to backup the source database, send it over the network and restore it on the destination. This is by design as most use...
Thank you for your feedback. I'll submit this as a feature request and hopefully we'll see it introduced in a future release. / comments
Thank you for your feedback. I'll submit this as a feature request and hopefully we'll see it introduced in a future release.
Have you tried it without the space in between stored and procedure? i.e.
<include>StoredProcedure</include> / comments
Have you tried it without the space in between stored and procedure? i.e.
<include>StoredProcedure</include>
I've tried this and it seems to work for me. I can type in EXEC sp_dboption and I'm given the parameters. This happens even when the query is under the focus of another database.
Are you using SQL Prompt 3.1? Have you ticked Include system objects in the candidate list, in the options under the Candidates tab? / comments
I've tried this and it seems to work for me. I can type in EXEC sp_dboption and I'm given the parameters. This happens even when the query is under the focus of another database.
Are you using SQL ...
Hi. Are you still having issues with SQL Prompt? If you are could you email support@red-gate.com and we can have a look into this issue for you.
Thanks / comments
Hi. Are you still having issues with SQL Prompt? If you are could you email support@red-gate.com and we can have a look into this issue for you.
Thanks
Do you have the SQL Prompt menu in Query Analyzer? Can you go to the options under this Menu and check that SQL Prompt Availability is turned to 'On'?
Can you right-click on the Prompt icon in the task bar? Is 'Start SQL Prompt when you start Query Analyzer' ticked? / comments
Do you have the SQL Prompt menu in Query Analyzer? Can you go to the options under this Menu and check that SQL Prompt Availability is turned to 'On'?
Can you right-click on the Prompt icon in the ...
Hi
Thanks for you're feedback.
I will forward your suggestion on to the developers. However, there is no set date for the next release of SQL Doc so I can't offer any indication as to when you might see this feature implemented.
Ben Pinchen
Technical Support Engineer
Red Gate Software Ltd
E-Mail: Support@red-gate.com / comments
Hi
Thanks for you're feedback.
I will forward your suggestion on to the developers. However, there is no set date for the next release of SQL Doc so I can't offer any indication as to when you migh...
You can automate the project using the Command Line Interface (you will need to have the Pro version of the software).
There is a help file for the Command Line Interface which includes a number of examples. This can be found by going to Start > All Programs > Red Gate Bundle 5 > The Command Line Interface.
In it’s simplest form you’d save the command below as a batch file and then use Windows scheduler to automate it.
sqldatacompare /project:"C:\Documents and Settings\username\Local Settings\Application Data\Red Gate\SQL Data Compare 5\project.sdc"
To see the possible options for using it, open a command prompt, navigate to the installation folder and type sqldatacompare /? / comments
You can automate the project using the Command Line Interface (you will need to have the Pro version of the software).
There is a help file for the Command Line Interface which includes a number of...
I'm not sure what you mean by 'after the event'. But I've tried the process below and it works for me.
If you copy the text, you want as the snippet, from the query pane. Then go to the Options, click on the Snippets tab and click New... You should be able to paste the code into the Code: box. / comments
I'm not sure what you mean by 'after the event'. But I've tried the process below and it works for me.
If you copy the text, you want as the snippet, from the query pane. Then go to the Options, cl...
I've looked into this and it is a bug in the software. I've notified the developers and they are hopefully going to fix this in a future version of SQL Prompt. / comments
I've looked into this and it is a bug in the software. I've notified the developers and they are hopefully going to fix this in a future version of SQL Prompt.