Siamack Hejazi - HotMail (siamakhejazi (AT) hotmail (DOT) com) writes:
If you don't want to drop and reload tables, then stay away from the
graphical stuff in Management Studio. It drops and reloads in a lot of
situations where it is not needed. Use ALTER TABLE from T-SQL instead.

Then again, depending on what changes you want to make, you may not be
able to escape reloading your tables anyway, since ALTER TABLE can't
do everything.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Siamack Hejazi - HotMail (siamakhejazi (AT) hotmail (DOT) com) writes:
If you don't want to drop and reload tables, then stay away from the
graphical stuff in Management Studio. It drops and reloads in a lot of
situations where it is not needed. Use ALTER TABLE from T-SQL instead.

Then again, depending on what changes you want to make, you may not be
able to escape reloading your tables anyway, since ALTER TABLE can't
do everything.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Siamack Hejazi - HotMail (siamakhejazi (AT) hotmail (DOT) com) writes:
If you don't want to drop and reload tables, then stay away from the
graphical stuff in Management Studio. It drops and reloads in a lot of
situations where it is not needed. Use ALTER TABLE from T-SQL instead.

Then again, depending on what changes you want to make, you may not be
able to escape reloading your tables anyway, since ALTER TABLE can't
do everything.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Siamack Hejazi - HotMail (siamakhejazi (AT) hotmail (DOT) com) writes:
If you don't want to drop and reload tables, then stay away from the
graphical stuff in Management Studio. It drops and reloads in a lot of
situations where it is not needed. Use ALTER TABLE from T-SQL instead.

Then again, depending on what changes you want to make, you may not be
able to escape reloading your tables anyway, since ALTER TABLE can't
do everything.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Siamack Hejazi - HotMail (siamakhejazi (AT) hotmail (DOT) com) writes:
If you don't want to drop and reload tables, then stay away from the
graphical stuff in Management Studio. It drops and reloads in a lot of
situations where it is not needed. Use ALTER TABLE from T-SQL instead.

Then again, depending on what changes you want to make, you may not be
able to escape reloading your tables anyway, since ALTER TABLE can't
do everything.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Siamack Hejazi - HotMail (siamakhejazi (AT) hotmail (DOT) com) writes:
If you don't want to drop and reload tables, then stay away from the
graphical stuff in Management Studio. It drops and reloads in a lot of
situations where it is not needed. Use ALTER TABLE from T-SQL instead.

Then again, depending on what changes you want to make, you may not be
able to escape reloading your tables anyway, since ALTER TABLE can't
do everything.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Siamack Hejazi - HotMail (siamakhejazi (AT) hotmail (DOT) com) writes:
If you don't want to drop and reload tables, then stay away from the
graphical stuff in Management Studio. It drops and reloads in a lot of
situations where it is not needed. Use ALTER TABLE from T-SQL instead.

Then again, depending on what changes you want to make, you may not be
able to escape reloading your tables anyway, since ALTER TABLE can't
do everything.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thanks friends;
Second question:

I designed a database and users working with that now . Assume, after 2
month I have an update for my database structure . How can I update my
database structure without manipulating the data's on that database. Please
explain in both method if exist.
1- With Transact SQL Codes
2 - In Microsoft SQL Server Management Studio
Thanks Again and apologize for beginners questions.

Sincerely
Siamack Hejazi
Sale Accounting Department Supervisor
Tabriz Petrochemical Complex
Iran

Thanks friends;
Second question:

I designed a database and users working with that now . Assume, after 2
month I have an update for my database structure . How can I update my
database structure without manipulating the data's on that database. Please
explain in both method if exist.
1- With Transact SQL Codes
2 - In Microsoft SQL Server Management Studio
Thanks Again and apologize for beginners questions.

Sincerely
Siamack Hejazi
Sale Accounting Department Supervisor
Tabriz Petrochemical Complex
Iran

Thanks friends;
Second question:

I designed a database and users working with that now . Assume, after 2
month I have an update for my database structure . How can I update my
database structure without manipulating the data's on that database. Please
explain in both method if exist.
1- With Transact SQL Codes
2 - In Microsoft SQL Server Management Studio
Thanks Again and apologize for beginners questions.

Sincerely
Siamack Hejazi
Sale Accounting Department Supervisor
Tabriz Petrochemical Complex
Iran