Posts
Sort by recent activity
SPv3 don't shows alter trigger code
Even it's working with alter proc and alter funcions, when I type alter trigger.. nothing happens (the SPv3 window don't show me the code).
Thanks
Ésio
Cache Settings
1 - Suggestion: in cache management window, can be a good idea inform date and time on column Last Cached, not only the date.
2 - Bug: I have one database called CP and another called CP_PRD. When ...
Refresh Cache cancelation.
Hi.
Accidentally I clickec Refresh all in Cache Management box. I take's me a long time. I pressioned this by mistake, I was found only one database refresh.
Maybe can be interesting a button "Canc...
Error generatin alter procs/functins script
A tested SPv3 with some procs and functions, but, in a specifc database, when I try to alter some functions (ex. dbo.fuQ_Banco), when I start typing the clause, SPv3 completes the function name, bu...
Memory use
Testing SPv3 in my production environment.
At this moment, 1 QA opened with 9 windows, using 3 different servers, and each windows pointing to a distinct database.
QA is consuming 110mb RAM, and wi...
Error typing the first column letter
Typing
select * from <ctrl spaces) -> ok it shows me the tables
I choosed the table and continue typing where <ctrl spaces) -> it ok, it shows me the columns, but in alphabetic order, it's be bett...
Duplicating from clause
Typing:
select * from <ctrl spaces) -> ok it shows me the tables
I choosed the table and continue typing:
where <ctrl spaces) ## the firts problem, it shows me all objects, not only my_table colum...
Error when pressing right arrow key
In SSMS, when pressing the right arrow key and moving the cursor to a new "text column", it's appear a message error box.
I started a query window with no script, I pressed the key, moving the curs...
Tab char completing table name
When checking the option Completion Keys -> Tab in Options Menu, SQL Prompts inserts a <tab> char after the name of the first table in query:
select * from TABLE<tab>
The shortcut letter "S" don't appear underlined in Query Ana
When pressing <alt> to access the menus in Query Analyzer, the letter "S" in SQL Prompt" don't appear like others shortcuts