Activity overview
Latest activity by steveg
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!)
Thanks for the quick response.
I changed the table name I was using in my original post... The two tables I was dealing with mostly yesterday were called "Name" and "Profile", which both get the bracket treatment.
However, other tables such as "Activity" and "Meeting" are not being bracketed.
Looks like a "this behaviour is by design". / comments
Thanks for the quick response.
I changed the table name I was using in my original post... The two tables I was dealing with mostly yesterday were called "Name" and "Profile", which both get the br...
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)