Posts
Sort by recent activity
Options page improvements
If I go to SQL Prompt 4 / Options, it will always display the Main/Behavior page, regardless of the last selected page.
It would be very nice to remember the last active one.
Also it would be very ...
Tooltip for sys.dm_db_index_physical_stats
The tooltip shown for sys.dm_db_index_physical_stats is is not correct.
It says:
dm_db_index_physical_stats (@DatabaseId, @IndexId, @Mode, @ObjectId, @PartitionNumber),
while books online says:
sys...
Synonyms aren't displayed in the candidate list
If I have a synonym for a table, like
create synonym T1 for DB.dbo.Table1
then T1 will not appear in the candidate list when I select from it (select * from T1)
This happens even if I refresh the s...
ALTER procedure formats the code instead of only inserting
Alter statement auto-completion will insert & format the code (two things).
This means that for any minor change inside a procedure not formatted according to the current SQL Prompt settings, the c...
HASHBYTES causes errors
If you try to type the following code in SSMS 2008:
select HASHBYTES ('MD5', 'test')
you get the following error at every key press while inside the parentheses:
See the end of this messa...
Identity seed causes an error
If you try to type the following code in SSMS 2008:
create table test (a int identity (1, 1))
you'll get an "Object reference not set to an instance of an object"
and the followin...
Temp tables and syntax highlighting
I know the temp tables are not implemented yet in SQL Prompt 4, but how will syntax highlighting work with them ?
Now, if the script references a table SQL Prompt doesn't know of (it's not in its c...
Row count
I noticed that to get the number of rows in a table, SQL Doc runs select count_big (*) from table_name; but that's very slow for large tables and puts huge load on the database, not talking about l...