Comments
Sort by recent activity
Many thanks for your post and your feedback regarding the product.
I have logged this request on our internal tracking system whose id is SP-2942.
It will be reviewed for a future release of SQL Prompt although we have no timescales for this at present.
I will update you as soon as this functionality is incorporated. / comments
Many thanks for your post and your feedback regarding the product.
I have logged this request on our internal tracking system whose id is SP-2942.
It will be reviewed for a future release of SQL Pr...
Thanks for letting us know.
I will definitely make a note of it. / comments
Thanks for letting us know.
I will definitely make a note of it.
Thanks for letting us know.
I will make a note of it.
Can you kindly let me know which version of SQL Prompt 4 you had installed on your machine? / comments
Thanks for letting us know.
I will make a note of it.
Can you kindly let me know which version of SQL Prompt 4 you had installed on your machine?
Many thanks for your post.
I am pleased to inform you that we have fixed the SQL Prompt issue you were experiencing in our latest patch.
Kindly check the forum post to download the version: https://www.red-gate.com/messageboard/v ... hp?t=10248
Please let us know if this fixes your issue. / comments
Many thanks for your post.
I am pleased to inform you that we have fixed the SQL Prompt issue you were experiencing in our latest patch.
Kindly check the forum post to download the version: https:/...
Thanks for your enquiry.
The error "SQL error 15404: Could not obtain information about Windows NT group/user" is generated by SQL Server, as SQL Server cannot connect to a Domain Controller in the domain to authenticate the account passed to it by SQL Backup.
When SQL Backup connects to SQL Server, it performs a security check to ensure that the user requesting the backup or restore task has permissions to perform the job. So for a scheduled backup job, this is the account given to the SQL Server Agent Service, for an ad-hoc backup using the SQL Backup GUI Backup Wizard, this is the logged in account using the GUI and for the backup attempt we made last night the logged account using SSMS. These security checks are known as the User Rights Check.
The above checks can be omitted or skipped by setting or adding a registry key called SkipChecks.
SQL Backup 5.3 and later will look for a registry key called SkipChecks, normally this registry does not exist. So SQL Backup will perform the User Rights Check as expected.
So to set the above Registry Key you will have to add it manually using the Registry Editor, regedit.
Using Regedit navigate to the following registry node:
HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\(local) or SQL Instance Name.
Create a new DWORD type key called SkipChecks and give the key a data value of 1.
SQL Backup will now see the SkipChecks Registry Key and omit the User Rights Check
I hope this helps. / comments
Thanks for your enquiry.
The error "SQL error 15404: Could not obtain information about Windows NT group/user" is generated by SQL Server, as SQL Server cannot connect to a Domain Controller in the...
Many thanks for your post.
This is not possible with SQL Prompt at the moment.
SQL Prompt can automatically insert code for table inserts though!
Can you explain your requirement with example that will help us to understand the issue better? / comments
Many thanks for your post.
This is not possible with SQL Prompt at the moment.
SQL Prompt can automatically insert code for table inserts though!
Can you explain your requirement with example that ...
No problem.
Let us know if you have any issues or questions regarding the product,I'll like to help. / comments
No problem.
Let us know if you have any issues or questions regarding the product,I'll like to help.
Did the above suggestion fixed the issue?
Kindly let us know if you have any issues or questions regarding the product,I'll like to help. / comments
Did the above suggestion fixed the issue?
Kindly let us know if you have any issues or questions regarding the product,I'll like to help.
Thank you for your post regarding SQL Prompt.
You can turn off SQL Server 2008 intellisense using the following settings:
Open Tools>Options>Text Editor>Transact-SQL>Intellisense. Is Intellisense disabled here?
Also if you click General under the Transact-SQL list is Auto list members and Parameter information not selected?
Kindly restart management studio after saving this settings and recheck it and try reproducing the issue?
Kindly let me know if this fixes the issue. / comments
Thank you for your post regarding SQL Prompt.
You can turn off SQL Server 2008 intellisense using the following settings:
Open Tools>Options>Text Editor>Transact-SQL>Intellisense. Is Intellisense d...
Many thanks for your post.
Your feedback is highly appreciated.
I have logged this feature request in our internal tracking system whose id is SP-2938.
It will be reviewed for a future release of SQL Prompt although we have not timescales for this at present.
Kindly let us know if you have any issues or questions regarding the product,I'll like to help. / comments
Many thanks for your post.
Your feedback is highly appreciated.
I have logged this feature request in our internal tracking system whose id is SP-2938.
It will be reviewed for a future release of S...