Description Column in Table Creation

Hello,
When you add a column you can put in a description. What
is the maximum size of this ?
Thanks
Peteruse extended properties, plenty of help in BOL
regards,
mark baekdal
www.dbghost.com
>--Original Message--
>Hello,
>When you add a column you can put in a description. What
>is the maximum size of this ?
>Thanks
>Peter
>.
>|||From BOL
[ @.value = ] { 'value' }
Is the value to be associated with the property. value is sql_variant, with
a default of NULL. The size of value may not be more than 7,500 bytes;
otherwise, SQL Server raises an error.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:0c8801c3d5de$45f3d6d0$a101280a@.phx.gbl...
> Hello,
> When you add a column you can put in a description. What
> is the maximum size of this ?
> Thanks
> Peter|||Thanks Guys
>--Original Message--
>Hello,
>When you add a column you can put in a description. What
>is the maximum size of this ?
>Thanks
>Peter
>.
>

Deployed files reduced size

I am wondering why deployed packages are so much smaller than built packages. What is removed and why isn't it removed when the packages are built?

I have a package that goes from 3Mb to 1.5Mb

Any answers|||We don't remove anything from package during deployment. The things that may affect package size:
1) XML encoding. UTF-16 (usually called just "Unicode") may take twice as much as UTF-8. I think we use UTF-8 in most places, but not sure.
2) Encryption. If you encrypt the whole package (instead of just sensitive information) it may noticeably increase package size.
How you do deploy, and to what location?|||

You're spot on with the unicode, which concerns me.

The package file in the bin folder is unicode with no directive in the xml clause i.e. <?xml version="1.0"?>, the deployed file is utf-8 but with the same xml directive.

The file is deployed by double clicking on the deployment manifest and selecting "file system".

Surely this is a problem if the package contains unicode, whats more it means the file being deployed isn't the file that is built. Thats not common practice

|||Interesting. Did you do anything special with the package?

I always get utf-8 encoded DTSX files (you are right, without encoding specified in XML clause): both the project folder and bin folder contain utf-8 encoded files. I don't know a way to make designer save utf-16 files.