add new field

Sql6.5
Are there any problems adding a "NEW" field to a table while table still
active but not in use ?
This field will be at aded to the end of the field list. I don't think
there should be any problem but not certain under 6.5Hi,
You can do it in SQL 6.5 when the table is active but not during a Insert /
Delete / Update statement or any other DDL on that object is in progress.
Thanks
Hari
MCDBA
"HartA" <Hoosbruin@.Kconline.com> wrote in message
news:#WHuntqFEHA.1268@.TK2MSFTNGP12.phx.gbl...
> Sql6.5
> Are there any problems adding a "NEW" field to a table while table still
> active but not in use ?
>
> This field will be at aded to the end of the field list. I don't think
> there should be any problem but not certain under 6.5
>|||And the new column have to allow NULL.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Hari" <hari_prasad_k@.hotmail.com> wrote in message news:uBtNWRtFEHA.2876@.TK2MSFTNGP09.phx.
gbl...
> Hi,
> You can do it in SQL 6.5 when the table is active but not during a Insert
/
> Delete / Update statement or any other DDL on that object is in progress.
> Thanks
> Hari
> MCDBA
> "HartA" <Hoosbruin@.Kconline.com> wrote in message
> news:#WHuntqFEHA.1268@.TK2MSFTNGP12.phx.gbl...
>