Losing description on export

  • We spent a lot of time puting in column descriptions on our local machine, but when we uploaded them to the host all the descriptions were gone and I couldn't upload sysproperties with the descriptions.  Is there any way to get them on the host?

  • If You are scripting the tables there is a checkbox for "include extended properties". Both in EM(Formatting Tab) and QA(Script Options).

    If you are using DTS I find it good practice to first script the tables & other objects, then use DTS to move the data.

    /rockmoose


    You must unlearn what You have learnt

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

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