You know how we’ve always heard that sp_msforeachtable and other similar undocumented functions may not be supported in future versions of SQL Server? Have you tried running something like this on any of your Windows Azure SQL Databases yet:
EXEC sp_msforeachtable 'select ''?'', count(*) from ?'
Try it out.
My Azure account got suspended after I tried to do some performance testing on it with 500 concurrent non-pooled connections. Hence I cannot try it.
However, I am really curious – please post the results of the undocumented features.
Feodor
Oh, it just gives an error saying you no such stored procedure exists. No big mystery.
Ah, tricky you! 🙂
By the way you had written the blog post I had all my hopes worked up…