I was trying to create another table and specify a data space, when I couldn't avoid noticing these weird elements on the list:

The thing is, I didn't create them. My storages are "PRIMARY" and "HDD_GROUP".

How did these appear? My googling skills are failing me, but that is a topic is not for today's jedi consult.

How are they used? Where are they located? What happens if I delete them?


To narrow it down, try a new query window in system management studio select * from sys.data_spaces

Reference the docs here: https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-data-spaces-transact-sql?view=sql-server-2017

That should lead you towards what they are.

  • Thank you. They are full-text partition-things, used by mssql to index texts. – AgentFire Oct 12 '18 at 14:59

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.