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 |
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
 Posted - 2009-04-22 : 00:11:33
|
| Hi Experts,While setting up the replication can any one tell me the difference between the below two commands and which is more advantageous on production servers.@pre_creation_cmd = N'drop' or the @pre_creation_cmd = N'truncate'Many thanks,Rao. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-04-22 : 09:52:52
|
| The question is not about "advantage". It should be more about requirements. The "drop" option drops an object on the subscriber if it already exists while creating a snapshot. The "truncate" option merely truncatets the date in the object. Dropping and creating objects can be an expensive operation.. and also any constraints/FK's need to be considered.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Replication properties