Comments
Sort by recent activity
Thanks for your post.
I could be wrong, but I don't think there would be any need to script the NOPARALLEL query hint when creating the index. As far as I can see the NOPARALLEL query hint is used to override the existing PARALLEL settings. If the index is created with NOPARALLEL then it is effectively like creating an index without the PARALLEL setting.
If I create an index in SQL Developer using the NOPARALLEL hint, then when I script out the DDL using SQL Developer, it doesn't mention the NOPARALLEL setting. I have a feeling Oracle doesn't even store the fact that the index was created with NOPARALLEL and treats it the same as an index that doesn't specify PARALLEL. / comments
Thanks for your post.
I could be wrong, but I don't think there would be any need to script the NOPARALLEL query hint when creating the index. As far as I can see the NOPARALLEL query hint is used ...
We have your Zendesk account associated with the same email address you have used for this forum. If you create your RedGateID with that same email address, you should see the tickets. Alternatively, you can just reply to the ticket instead of logging into the support portal.
Sorry for the inconvenience. / comments
We have your Zendesk account associated with the same email address you have used for this forum. If you create your RedGateID with that same email address, you should see the tickets. Alternativel...
That's great. Maybe we should rebrand to 'ingenuinely simple' [image] / comments
That's great. Maybe we should rebrand to 'ingenuinely simple'
I believe that means you need to make sure the logon account for the SQL Backup agent has permissions to that key.
If you open up regedit on the server, you should be able to find the key. I suggest granting full access for the SQL Backup agent logon account to BackupSettingsGlobal.
I hope this helps. / comments
I believe that means you need to make sure the logon account for the SQL Backup agent has permissions to that key.
If you open up regedit on the server, you should be able to find the key. I sugges...
This is actually something that people have been requesting for a while, but unfortunately we don't have any plans to change the way it works at the moment.
There is a workaround you can use to allow non sysadmin users to backup. See the following topic: http://www.red-gate.com/MessageBoard/vi ... 7970#27970
We don't have any useful training videos for setting up service rights (which we probably should). However, where 3rd party SQL Server backup tools are concerned, they mostly all leverage a SQL Server virtual device, and in order to create a virtual device, the account needs to be a member of the sysadmin fixed server role. We can't really get around it, so you don't really get a lot of choices with regards to the types of account you can use for the services.
The logon account for the UI or the SQLAgent service will be 'users' for the job, so they should be able to be non sysadmins. I apologize that isn't possible with SQL Backup, but the workaround should hopefully help. / comments
This is actually something that people have been requesting for a while, but unfortunately we don't have any plans to change the way it works at the moment.
There is a workaround you can use to all...
Thanks for your reply.
That would indicate that the user that initiates the job doesn't have permission to backup that particular backup.
If the job is started by the SQLAgent, check that the logon account for the SQLAgent service has permissions to backup the database in question.
Can you backup the database manually using the SQL Backup UI? / comments
Thanks for your reply.
That would indicate that the user that initiates the job doesn't have permission to backup that particular backup.
If the job is started by the SQLAgent, check that the logon...
Thanks for your post.
I'm afraid there aren't any plans to add features to SQL Multi-Script at the moment. However, this is quite a popular suggestion and is currently logged under the code SE-65.
I'll put you down as another vote for it, but unfortunately there is unlikely to be any development effort on SQL Multi-Script in the near future. / comments
Thanks for your post.
I'm afraid there aren't any plans to add features to SQL Multi-Script at the moment. However, this is quite a popular suggestion and is currently logged under the code SE-65.
...
I'll reply to this via the support ticket we have open for you as I'll need to ask for your serial number.
Regards, / comments
I'll reply to this via the support ticket we have open for you as I'll need to ask for your serial number.
Regards,
Thanks for your post.
It sounds like you should be able to do what you need.
1. Go to the 'Tables & Views' tab, and only select: processes, templates, roles, and products
2. For each of the tables/views you're comparing, set a WHERE clause to match on any rows where the update dates don't match.
3. When you sync' make sure you use the pdsysadmin account, so that is the account used to update the target. that is assuming the last edited field is populated by the user account.
If this doesn't help, you could probably get most of the way there using this method, and then just output the deployment script and edit it to fit your requirements.
I hope this helps. / comments
Thanks for your post.
It sounds like you should be able to do what you need.
1. Go to the 'Tables & Views' tab, and only select: processes, templates, roles, and products
2. For each of the tables/...
yes, it's only a minor upgrade so your serial number will be valid. / comments
yes, it's only a minor upgrade so your serial number will be valid.