|
Home > Archive > MS SQL Server > May 2005 > Db object script
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]
|
|
| Gopinath S 2005-05-23, 3:23 am |
| Hi,
While generating the script for dbobjects iam getting the following
script ,
I would like to know the significance of this statement or direct me to
the place where I can get the information.
Regards
Gopinath
update syscolumns
set typestat = (Convert(int, 0xff) ^ 0x02) & typestat
where syscolumns.id = object_id(‘dbo.tName’) and
syscolumns.name in (‘fQuestion’) and
syscolumns.xoffset <> 0
| |
| Mike Epprecht (SQL MVP) 2005-05-23, 3:23 am |
| Hi
typestat in sycolumns is an internal value that should not be modified.
Actually, any direct update of any system tables should not be attempted as
that functionality breaks in SQL Server 2005.
The script yopu are running sets the bit flag for TrimTrailingBlanks On.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Gopinath S" wrote:
> Hi,
> While generating the script for dbobjects iam getting the following
> script ,
> I would like to know the significance of this statement or direct me to
> the place where I can get the information.
> Regards
> Gopinath
>
>
> update syscolumns
> set typestat = (Convert(int, 0xff) ^ 0x02) & typestat
> where syscolumns.id = object_id(‘dbo.tName’) and
> syscolumns.name in (‘fQuestion’) and
> syscolumns.xoffset <> 0
>
| |
| Gopinath S 2005-05-23, 3:23 am |
| Mike Epprecht (SQL MVP) wrote:[color=darkred
]
> Hi
>
> typestat in sycolumns is an internal value that should not be modified.
> Actually, any direct update of any system tables should not be attempted as
> that functionality breaks in SQL Server 2005.
>
> The script yopu are running sets the bit flag for TrimTrailingBlanks On.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
>
>
> "Gopinath S" wrote:
>
>
Thanks for the information
|
|
|
|
|