Presenting "What's New in SQL Server Denali" for WVPASS

Hi Aaron,

I noticed in your MetaDiscovery.sql Demo 3 you say it does not work for temp tables.....

What if you use:

EXEC tempdb.sys.sp_describe_first_result_set N'DECLARE @x TABLE(i INT);SELECT i FROM @x;';

EXEC tempdb.sys.sp_describe_first_result_set N'CREATE TABLE #y (j INT);SELECT j FROM #y;';

GO

its similar to the work around to get object_ids for temp tables

Ah thanks Aaron

I'm looking forward to getting my hands on Denali - quite a few of the new functionality shown in your demo scripts would be really useful on my projects