How can we help you today? How can we help you today?
Dave Pendleton
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...
1 follower 1 comment 0 votes
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 ...
1 follower 2 comments 0 votes
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?
2 followers 2 comments 0 votes
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...
1 follower 1 comment 0 votes
CURRENT_TIMESTAMP inserted incorrectly
SQL Prompt insertsCURRENT_TIMESTAMP() This is incorrect, the function does not allow (or require) the parens.
2 followers 5 comments 0 votes
Problem with GO
What is the problem with "GO"? Perhaps three times out of 100, I actually see "GO" as a listed candidate, the other 97 times, I get "GOTO". I'm getting tired of having to ESCape or backspace over a...
3 followers 8 comments 0 votes
Feature request
I often use SQL Doc as a discovery tool at new clients, or on new projects. How about adding the server and database configuration settings to the output, as well? Being able to include/exclude ext...
1 follower 1 comment 0 votes
What's with system stored procedures?
I use sp_help (and its variants) quite frequently. SQL Prompt either does not recognize these procedures at all (yes, I've registered master), or offers up User-defined functions as the only sugges...
2 followers 3 comments 0 votes
Nice job
But, what good is a single server version? If I want to execute scripts on a single server, I'll use Query Analyzer or Management Studio... Come on guys, entry level should support 2 servers -- at ...
2 followers 4 comments 0 votes
Ignoring certain words?
I've just started using SP, and I like it so far. However, there are certain words (GO in particular) that I would like SP to ignore completely. I've looked at the candidate list, and in the case o...
1 follower 1 comment 0 votes