ms_sptablespace won't work against other's tables

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 1

Thanks for the tip. I will check this out.

Would you want to submit this as an FAQ?

Steve Jones

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 2

It does work, but you have to enclose the owner and name in quotes. For instance:



EXEC sp_MStablespace 'joe.tableA'

K. Brian Kelley

K. Brian Kelley
@kbriankelley