I originally created an SQL 2000 database from Access 2000. I stored the
field descriptions in Access 2000 but they didn't transfer over during the
DTS.

How do I get these descriptions back into my SQL Server 2000 database?

I've generated the script and have made some changes to the SQL database,
like changing the data types and sizes. Now, I want to add in the
descriptions. I've looked at the syntax for CREATE TABLE but can't find
anything remotely close except for column_description. Even when I try to
type a description into the already created table, I get errors. I know I
must use the "EXECUTE sp_addextendedproperty ..." command code to include the
descriptions.

Is there an easier way than to go through all the tables and get every field
that has a definition? I started to create the object definition from the
analysis tool option but it does not save the table definition info. Is
there a way to save this to create a table and pull out the definitions?

It's not necessarily all that easy to manage extended
properties in SQL Server. If you want an easy way, you can
try third party tools. One is from A&G Software:
http://www.ag-software.com/sepe/

-Sue

On Mon, 16 May 2005 13:28:01 -0700, "R.V." <R.V. of the
MidAtlantic (AT) discussions (DOT) microsoft.com> wrote: