sp_MSTableSpace and sp_MSforeachtable combined

,

The following stript combines two previous articals. sp_MStablespace was being demonstrated with a cursor. To reduce the code the sp_MSforeachtable could be used.

EXECUTE sp_MSforeachtable 
        @command1=" Print '?' EXECUTE sp_MStablespace '?'"

Rate

3 (2)

Share

Share

Rate

3 (2)