May 24 2013

A Little Azure Fun on Friday

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.

3 Comments

  • By Feodor, May 25, 2013 @ 2:39 am

    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

  • By Grant Fritchey, May 25, 2013 @ 5:41 am

    Oh, it just gives an error saying you no such stored procedure exists. No big mystery.

  • By Feodor, May 27, 2013 @ 2:07 am

    Ah, tricky you! :)
    By the way you had written the blog post I had all my hopes worked up…

Other Links to this Post

RSS feed for comments on this post. TrackBack URI

Leave a comment