Activity overview
Latest activity by pburleson
VIEW SERVER STATUS Permission?
Hello,
I'm curious why a user needs VIEW SERVER STATUS permissions for SQL Prompt to work?
I have a user that's dbo on his database, but gets an error during SQL Prompt Caching the data for his dat...
Michelle,
Thanks for the reply. I realized I've posted this in the wrong forum, but the same is true for SQL Data Compare. Could you open a ticket for that product as well?
Thanks,
Patrick / comments
Michelle,
Thanks for the reply. I realized I've posted this in the wrong forum, but the same is true for SQL Data Compare. Could you open a ticket for that product as well?
Thanks,
Patrick
Using project file but changing databases via command line
I've setup a project file for our database structure that took quite a while to get right because there were many timestamps and user id columns I need to exclude.
I wanted to use that project file...
JOIN Layout Suggestion
We've been looking at using SQL Prompt 3 to apply a consistent layout to our SQL Code and after working with our team, we have a suggestion. Within the Data Statements, for JOINS, allow having the ...
I'd like to throw in a vote for this change as well. We're looking at using SQL Prompt to reformat our code and having BEGIN/END on the same tab stop is the IF/ELSE would be preferred. / comments
I'd like to throw in a vote for this change as well. We're looking at using SQL Prompt to reformat our code and having BEGIN/END on the same tab stop is the IF/ELSE would be preferred.
After some further investigation, it does appear that SQL Prompt only automatically provides a table list based on FK constraints. If you start typing a table name and hit ctrl-space, the popup list comes back. It would be nice to make it an option to have it disregard FK requirements and show all tables after JOIN .
Patrick / comments
After some further investigation, it does appear that SQL Prompt only automatically provides a table list based on FK constraints. If you start typing a table name and hit ctrl-space, the popup lis...
I just ran into this using aliases for something like:
select * from foo f where f.
and there were other table names that start with f, so it completed the first one. Funny thing, f.column_name was lower in the list.
Maybe SQL Prompt should sort those to the top or recognize the use of an alias and not perform completion, but instead perform another suggestion after hitting "."
Patrick / comments
I just ran into this using aliases for something like:
select * from foo f where f.
and there were other table names that start with f, so it completed the first one. Funny thing, f.column_name was...
No Table list after "JOIN"
If I type
select * from <>
I get the table popup at <>, continuing:
select * from foo f Join <>
I don't get a popup at <>, not even with Ctrl-Space. But I start typing a table name
select * from fo...