I am keen for tool pack features too, especially #region tags

@Justin @Stephen - Here at Red Gate we totally agree that query execution history and scripting of INSERTS are great features and well worth the additional €25 for the SSMS Tools Pack! @Jason - Tab History will be a fully integrated feature in SQL Prompt. It's not quite the same as an execution history but for some use cases serves a similar purpose.

The scripting of INSERTs from the results grid is a great feature that isn't available AFAIK anywhere else, and the "Find in Results" is really helpful, too.

+3 for these two features!

I think this can be marked complete for the "Query Execution History". SQL Tab Magic 2012 is very close to the same. The snippet manager is getting closer to custom scripting but SSMS Tools pack custom scripting is nice that I can do it on any column, table, view, etc.

Vote from me for the Query Execution History, especially now that SSMSTools requires a licence for SQL2012!!

I love the custom scripting.
Examples that I use everyday.

Add Extended Properties
DECLARE @type varchar(50), @timestamp DATETIME

SELECT @type=CASE WHEN [type] = 'U'
THEN 'TABLE'
WHEN [type] = 'V'
THEN'VIEW'
WHEN [type] = 'P'
THEN 'SQL_STORED_PROCEDURE'
WHEN [type] = 'PK'
THEN 'PRIMARY_KEY_CONSTRAINT'
WHEN [TYPE] = 'D'
THEN 'DEFAULT_CONSTRAINT'
WHEN [type] = 'FN'
THEN 'SQL_SCALAR_FUNCTION'
END
FROM sys.objects
WHERE [NAME] = '|ObjectName|'

SELECT @timestamp=GETDATE()

EXEC sys.sp_addextendedproperty @name=N'Created by', @value=N'Jason Clements' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=@type,@level1name=N'|ObjectName|'

EXEC sys.sp_addextendedproperty @name=N'Purpose', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=@type,@level1name=N'|ObjectName|'

EXEC sys.sp_addextendedproperty @name=N'Created on', @value=@timestamp, @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=@type,@level1name=N'|ObjectName|'
GO

-------------------------------------------------------------------------------
MAXDates

declare @tab table (id int identity(1,1) primary key,SQLname varchar(50))
insert into @tab(SQLname)

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE DATA_TYPE IN ('datetime', 'smalldatetime')
AND TABLE_NAME = (N'|ObjectName|')

declare @sql varchar(8000), @i int,@count int, @sqlname varchar(50)

set @i=1
select @count= count(*) from @tab
while @i <= @count

begin
select @SQLname=SQLname from @tab where id=@i

set @sql = '

USE |DatabaseName|
SELECT MAX('+@SQLname+') AS Max_Date_'+@SQLname+'

FROM |ObjectName|
'

--print @sql
exec (@sql)

set @i=@i+1
end

And I agree with what both state, but SSMS ToolsPack has gone for a pay for software direction. I would suggest that RedGate work with them to allow purchasers of SQL Prompt Pro to use the newer version for free.

Thanks for the comment. We've actually had the query history on our backlog for a while, even before it appeared in the SSMS Tools Pack. To avoid feature overlap we've focused on other things for now. There should be no reason why you can't use both tools alongside each other. We'll definitely considering adding in sometime in future, but it's not an immediate priority for now.