|
Home > Archive > MS SQL Server > March 2006 > column description in tables design
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
column description in tables design
|
|
| Dan D. 2006-03-26, 8:23 pm |
| Using SS2000. When we design a new table in EM, we often put text in the
description field for each column. We tried copying the table as an object
via DTS to a new server/database and everything seems to transfer except the
descriptions.
Is there a way to transfer the descriptions? Where are they stored? I can
run this query to see what the descriptions are but I can't look inside the
function to see where it's pulling the info from.
SELECT objname, value
FROM ::fn_listExtendedPro
perty(NULL, 'user', 'dbo', 'table',
'tblleads_branch', 'column', null)
Thanks,
--
Dan D.
| |
| Ben Nevarez 2006-03-26, 8:23 pm |
|
I have not tested it but the DTS Import/Export Wizard, when you select Copy
objects and data between SQL Server databases, has the choice to include
extended properties, unchecked by default. Just check that box and that
should work.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Dan D." wrote:
> Using SS2000. When we design a new table in EM, we often put text in the
> description field for each column. We tried copying the table as an object
> via DTS to a new server/database and everything seems to transfer except the
> descriptions.
>
> Is there a way to transfer the descriptions? Where are they stored? I can
> run this query to see what the descriptions are but I can't look inside the
> function to see where it's pulling the info from.
>
> SELECT objname, value
> FROM ::fn_listExtendedPro
perty(NULL, 'user', 'dbo', 'table',
> 'tblleads_branch', 'column', null)
>
> Thanks,
>
>
> --
> Dan D.
| |
| Dan D. 2006-03-27, 9:23 am |
| It did. Thanks.
--
Dan D.
"Ben Nevarez" wrote:
[color=darkred]
>
> I have not tested it but the DTS Import/Export Wizard, when you select Copy
> objects and data between SQL Server databases, has the choice to include
> extended properties, unchecked by default. Just check that box and that
> should work.
>
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
>
> "Dan D." wrote:
>
|
|
|
|
|