Problems when renaming a table after snapshot applied

Hello,
What problems can I expect to find (if any) when renaming a table after a
snapshot publication is applied? I would like to know how will the indexes,
transaction log, foreign keys, etc. be affected by this rename, it will be
done on a daily basis for a table that consists of 20-30 millions records.
I would have 2 identical tables. One named "TableA" and the other named
"TableA_REPLICATED". The snapshot publication will be applied to
"TableA_REPLICATED", when its done, "TableA" will be renamed to something
else and "TableA_REPLICATED" renamed to "TableA" using a post-script. This
process will continue and will run once a day.
Do you see any major problems with this?
Johnny
If you are using snapshot replication it should be problem free.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Johnny" <Johnny@.discussions.microsoft.com> wrote in message
news:28DF0243-8793-48E8-98E6-C5D499EB2932@.microsoft.com...
> Hello,
> What problems can I expect to find (if any) when renaming a table after a
> snapshot publication is applied? I would like to know how will the
indexes,
> transaction log, foreign keys, etc. be affected by this rename, it will be
> done on a daily basis for a table that consists of 20-30 millions records.
> I would have 2 identical tables. One named "TableA" and the other named
> "TableA_REPLICATED". The snapshot publication will be applied to
> "TableA_REPLICATED", when its done, "TableA" will be renamed to something
> else and "TableA_REPLICATED" renamed to "TableA" using a post-script. This
> process will continue and will run once a day.
> Do you see any major problems with this?
> Johnny
>