Posts
Sort by recent activity
Erratic Tooltips
Why are tooltips present for some columns/objects and not for others?
When working on a SELECT statement with multiple JOIN clauses, tooltips appear for some columns/tables but not for others.
The ...
Disabling/Removing Snippets
How does one disable or remove snippets?
I do not want them suggested while typing.
Thanks.
Uh, what just happened?
I installed SQL Prompt 4 this morning.
I've been happily coding in both Visual Studio and SMSS all day, formatting away as I go, then bang.
Nothing.
Every format operation left justfies all the SQL...
Moving Alert Repository
I would like to move my current repository off my workstation and on to a proper server.
I would like to export my current repository to this new server.
Can this be done?
JOIN no longer on new line?
My JOIN clauses are no longer on a new line, and no setting seems to affect this.
What happened?
What controls this formatting?
What setting controls the following?
This is the closing parens of a CREATE TABLE statement.)
ON
[PRIMARY] ;
Why the indent of "ON", and "[PRIMARY]" on a new line?
Also I have bee...
Removing unused or unneeded servers
How do I get rid of unused or unneeded servers from the Database Distribution List?
I frequently use instances of SQL Server on VM's and I don't want these appearing in my distribution lists after ...
3.8 and VS2K8
Where are the menus for SQLPrompt in VS2K8?
It appears to be working, but there are no menus (or toolbars) available.
Any ideas?
Stuck in master...
I am working on a ~3000 line script that references objects in several other databases, including master.
I am refactoring the code as I go, primarily adding object ownership qualifiers via the "Qu...
CURRENT_TIMESTAMP inserted incorrectly
SQL Prompt insertsCURRENT_TIMESTAMP()
This is incorrect, the function does not allow (or require) the parens.