Activity overview
Latest activity by Aaron L
Hi TGallant,
Thanks for your post!
I'm not sure I completely understand the permissions you'd like to adjust - Would you be able to go into a little more detail for the current manual process that you're using to adjust the permissions?
We're currently doing some research into access control/permissions on the SQL Clone web interface, as well as ways to mask data. However I'm not sure if either of those would help you. Any more details you could provide on what you'd like to see would be greatly appreciated!
Thanks,
Aaron. / comments
Hi TGallant,
Thanks for your post!
I'm not sure I completely understand the permissions you'd like to adjust - Would you be able to go into a little more detail for the current manual process that ...
Hi Luis,
Thanks for you post - Just to make sure we're talking about the same issue, is this error just after SQL Clone was installed?
After installing SQL Clone the installer should try to open a new web browser session pointing to the newly installed web server, it sounds like this might have failed for some reason.
The web server should be on your machine on port 14145, could you try opening another browser window and try navigating to http://localhost:14145?
Thanks,
Aaron. / comments
Hi Luis,
Thanks for you post - Just to make sure we're talking about the same issue, is this error just after SQL Clone was installed?
After installing SQL Clone the installer should try to open a ...
Latest stable build of SQL Prompt is 7.3.0 (5th December)
SQL Prompt 7.3.0.775 - 5th December 2016
This build of SQL Prompt includes:
New Format SQL experimental feature
The formatting is now more customisable
More options for:
CASE (UserVoice)
JOIN (Us...
Hi ogrishman,
We've just released a new beta build which should allow you to enter multiple lines using shift+enter. Please give it a go and let me know if it works as you'd expect.
Thanks,
Aaron. / comments
Hi ogrishman,
We've just released a new beta build which should allow you to enter multiple lines using shift+enter. Please give it a go and let me know if it works as you'd expect.
Thanks,
Aaron.
Hi ogrishman,
Thanks for your post – these user placeholders/tab stops were originally designed just for short single line replacements, however it does look like they function for multi-lined values too. I'll have a quick look to see how much work it'd be to allow you to enter multiple lines in the GUI.
Thanks,
Aaron. / comments
Hi ogrishman,
Thanks for your post – these user placeholders/tab stops were originally designed just for short single line replacements, however it does look like they function for multi-lined va...
Hi ggeier,
Unfortunately at the moment SQL Prompt doesn't have a setting to achieve what you want. As [name] isn't a full keyword the brackets are unnecessary. If you had a column named with a full keyword like or [select] however then the brackets would be necessary and kept.
I think we've got a UserVoice request for improving this here: https://redgate.uservoice.com/forums/94 ... ssary-brac
If that's what you're thinking of please do add your vote! We use the votes to help prioritise what will be worked on next and you'll get an email when we release a new build with it in.
Thanks,
Aaron. / comments
Hi ggeier,
Unfortunately at the moment SQL Prompt doesn't have a setting to achieve what you want. As [name] isn't a full keyword the brackets are unnecessary. If you had a column named with a full...
No problem [image] glad you got to the bottom of it! / comments
No problem glad you got to the bottom of it!
Hi mbourgon,
Another thing to check is do you have any other addins installed that might be causing this? (eg. I think SSMS Tools Pack comes with the snippet "ex" which expands to "EXISTS" which could explain what you're seeing)
Thanks,
Aaron. / comments
Hi mbourgon,
Another thing to check is do you have any other addins installed that might be causing this? (eg. I think SSMS Tools Pack comes with the snippet "ex" which expands to "EXISTS" which co...
Hi mbourgon,
I'm looking into this now, however I've been unable to reproduce it locally.
The exact steps I used were:
1) Create a table using: CREATE TABLE MYTABLE (EXTRACT_DETAIL INT);
2) Refresh SQL Prompt's suggestions
3) In a new query window type "SELECT * FROM MYTABLE WHERE ext"
4) Hit enter - I always get EXTRACT_DETAIL completed.
I'm wondering if I might need another step to reproduce this. If you follow the exact same steps on a new database (to rule out it being something else on your database interfering) are you still seeing EXISTS being completed?
Thanks,
Aaron. / comments
Hi mbourgon,
I'm looking into this now, however I've been unable to reproduce it locally.
The exact steps I used were:
1) Create a table using: CREATE TABLE MYTABLE (EXTRACT_DETAIL INT);
2) Refres...
Hi ogrishman,
This is by design as sysname acts more like a user defined data type than a built-in data type and needs to be lower case for it to be recognised on case sensitive databases.
(From https://technet.microsoft.com/en-us/lib ... 91240.aspx: Important: In databases that are case-sensitive, or that have a binary collation, sysname is recognized as a SQL Server system data type only when it appears in lowercase.)
Thanks,
Aaron. / comments
Hi ogrishman,
This is by design as sysname acts more like a user defined data type than a built-in data type and needs to be lower case for it to be recognised on case sensitive databases.
(From ht...