title: Where are extended properties stored in SQL Server?
body: <p>Where are extended properties stored in SQL Server?</p>
  
  <p>Are they stored in the database containing the object it was added to, or are they stored separately and bound to the local machine somehow.</p>
  
  <p>For example, if I add populate the "Description" field (MS_Description extended property) in SSMS to document a table's column, and I then shut down the database engine and copy the MDF/LOG files out to attach it to a different machine, will the extended properties go with the copied file, or will they get left behind in the master database (or something like that) on the local machine?</p>