Posts
Sort by recent activity
Open Generator Project when no database exists
I can't open a generator project if the database it was built for doesn't exist or isn't accessable. I would like to be able to point a generator project at different databases.
My workaround is to...
CLR Functions/Procs
SQL Prompt 4 does not list the available clr functions and methods, correct? Will this be added?
Thanks,
Dan
Programmatically adding snippets
I want to add snippets programatically, i.e. write a script to generate the snippets. The format of the snippet files doesn't seem to be documented, but it looks fairly easy to figure out but I hav...
disable SQL Prompt 4
I've updated to SQL Prompt 4. How can I disable it? For some presentations that I do I need to be able to run SSMS in it's plain form. In SQL Prompt 3 there was a disable button on the menu.
hierarchyid
Data Generator will generate hierarchyid's but the results don't seem to be all that useful, that is they are just randomly generated as other kinds of values are. It would be very useful if it gen...
feature req., symbol legends
I would be good to definitions of the various symbols Sql Doc produces right in the html/help itself. I would make it much easier for the consumers of the documentation to use it. Not everyone usin...
SESSION_USER function
SQL Prompt adds a () to SESSION_USER when it inserts it like so:
DECLARE @su NVARCHAR(128)
SET @su = SESSION_USER() -- SQL Prompt added the ()
However SESSION_USER() generates a syntax error. SESSI...
sys schema
Dependency tracker seems to not track full names of system resources. For example with the following stored procedure like:
CREATE PROC TEST
AS
SELECT * from sys.extended_properties
produces an unr...
sp_addmessage
I have just noticed that SQL Doc does not document the user messages in a database. It would be very good to add this features.
Thanks,
Dan
CREATE CREDENTIAL
CREATE CREDENTIAL does not seem to be baked into Sql Prompt.
Dan