Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-25 : 08:10:28
|
| raveendra writes "dear sir,i have two sql servers2000 sp3 one in internet to present the data another one in the intranet.the two sql servers are connected using sql server authentication.i used to transfer the data from intranet server to internet server(very large data tables).Actually they are time consuming. i have created packeges also.In the internet server the tables must be indexed.In the packeges i have mentioned drop and recreate table in the destination server so every time i have to index the tables in the internet server.can u suuggest me a stored procedure which can take care of my transferring fresh tables to the internet server and automatic creation of cluster index on one column and indexes on two other columns.i dont want to delete the data from the destination table as it might cause the visitor inconvenience.Plese give me the solution as soon as possible for which i will be grateful to u sir." |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-09-25 : 08:15:52
|
What about Replication  - Sekar |
 |
|
|
|
|
|
stored procudure