Posts
Sort by recent activity
SqlPrompt, a great way to view encrypted stored procedures
Did you know SqlPrompt is a great way to view encrypted stored procedures?
For instance, I am unable to use sp_helptext, syscomments or SqlServer Management Studio to view encrypted stored procedur...
INSERT [ + tab expansion occasionally places ] incorrectly
3.6.109
Typing "INSERT [MyT" and then pressing TAB (after the drop down appears) to complete can result in the ] being placed incorrectly:
insert [#MyTable (
ID
) ]
This can be a little fiddly to ...
sp_helptext popup contents does not contain SPs or views.
After typing sp_helptext the popup does not contain stored procs or views, only functions are listed.
Version 3.6.0.109.
(BTW cross-database popups, thank you!)
Bug: Surround with Bracket option doesn't affect FROM clause
Unchecking the Surround With Brackets option doesn't have any affect in the FROM clause.Select * from [MyTable] where id = 1
(Query Analyzer 8.0.760, SqlServer2000 SP3)