in SQL 2000, you can use exec sp_repladdcolumn to add a column into a replicated table, system will propagate the change to suscriber automatically

in SQL 2005, you can use "alter...

There are two ways to recover a single data file DB in SQL 2005.

1. Create DB for attach ...

CREATE DATABASE database_name

ON [ ,...n...

We got the same issue insql 2005, a compicated SQL statement stuck the process for ever. you can update statistics, then it will get faster. SQL 2005 is very sensitive...